Overview

Brought to you by YData

Dataset statistics

Number of variables	43
Number of observations	22788
Missing cells	139329
Missing cells (%)	14.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	7.5 MiB
Average record size in memory	344.0 B

Variable types

Numeric	19
Categorical	14
Text	8
DateTime	2

Alerts

`AMORTIZACION` is highly overall correlated with `CODIGO_TIPO_AMORTIZACION` and 7 other fields	High correlation
`AÑO_REGISTRO` is highly overall correlated with `AÑO_VENCIMIENTO` and 8 other fields	High correlation
`AÑO_VENCIMIENTO` is highly overall correlated with `AÑO_REGISTRO` and 9 other fields	High correlation
`CANTIDAD_CUOTAS_PAGADAS` is highly overall correlated with `AÑO_REGISTRO` and 9 other fields	High correlation
`CODIGO_CLIENTE` is highly overall correlated with `DELEGACION_MUNICIPIO` and 2 other fields	High correlation
`CODIGO_MONEDA` is highly overall correlated with `AÑO_REGISTRO` and 7 other fields	High correlation
`CODIGO_TIPO_AMORTIZACION` is highly overall correlated with `AMORTIZACION` and 7 other fields	High correlation
`CODIGO_TIPO_IDENTIFICACION` is highly overall correlated with `DELEGACION_MUNICIPIO` and 4 other fields	High correlation
`DELEGACION_MUNICIPIO` is highly overall correlated with `AMORTIZACION` and 30 other fields	High correlation
`DESC_LINEA_FINANCIERA` is highly overall correlated with `AMORTIZACION` and 5 other fields	High correlation
`DIA_VENCIMIENTO` is highly overall correlated with `DELEGACION_MUNICIPIO`	High correlation
`ENTIDAD_FEDERATIVA` is highly overall correlated with `AMORTIZACION` and 26 other fields	High correlation
`MES_REGISTRO` is highly overall correlated with `DELEGACION_MUNICIPIO` and 3 other fields	High correlation
`MES_VENCIMIENTO` is highly overall correlated with `CANTIDAD_CUOTAS_PAGADAS` and 3 other fields	High correlation
`MONTO_APROBADO` is highly overall correlated with `AÑO_VENCIMIENTO` and 7 other fields	High correlation
`MONTO_DISPONIBLE` is highly overall correlated with `DELEGACION_MUNICIPIO` and 2 other fields	High correlation
`MONTO_INICIAL` is highly overall correlated with `AÑO_VENCIMIENTO` and 7 other fields	High correlation
`NACIONALIDAD` is highly overall correlated with `DELEGACION_MUNICIPIO` and 2 other fields	High correlation
`NO_EMPLEADOS` is highly overall correlated with `CODIGO_CLIENTE` and 4 other fields	High correlation
`NUMERO_CONTRATO` is highly overall correlated with `AÑO_REGISTRO` and 9 other fields	High correlation
`NUMERO_CUOTAS` is highly overall correlated with `AÑO_REGISTRO` and 11 other fields	High correlation
`NUMERO_PRESTAMO` is highly overall correlated with `AÑO_REGISTRO` and 9 other fields	High correlation
`PAIS` is highly overall correlated with `DELEGACION_MUNICIPIO` and 2 other fields	High correlation
`PLAZO` is highly overall correlated with `AMORTIZACION` and 13 other fields	High correlation
`PRODUCTO` is highly overall correlated with `AMORTIZACION` and 9 other fields	High correlation
`SEXO` is highly overall correlated with `CODIGO_TIPO_IDENTIFICACION` and 8 other fields	High correlation
`TASA_TOTAL` is highly overall correlated with `CODIGO_MONEDA` and 2 other fields	High correlation
`TIPO_SECTOR` is highly overall correlated with `DELEGACION_MUNICIPIO` and 2 other fields	High correlation
`TIPO_SUBSECTOR` is highly overall correlated with `AMORTIZACION` and 6 other fields	High correlation
`TIPO_TASA` is highly overall correlated with `AMORTIZACION` and 6 other fields	High correlation
`VALOR_CUOTA` is highly overall correlated with `DELEGACION_MUNICIPIO` and 4 other fields	High correlation
`VENTAS_NETAS` is highly overall correlated with `DELEGACION_MUNICIPIO` and 3 other fields	High correlation
`PAIS` is highly imbalanced (99.9%)	Imbalance
`NACIONALIDAD` is highly imbalanced (99.9%)	Imbalance
`PRODUCTO` is highly imbalanced (64.0%)	Imbalance
`CODIGO_MONEDA` is highly imbalanced (76.4%)	Imbalance
`TIPO_TASA` is highly imbalanced (50.0%)	Imbalance
`NOMBRES` has 15849 (69.5%) missing values	Missing
`PRIMER_APELLIDO` has 15849 (69.5%) missing values	Missing
`SEGUNDO_APELLIDO` has 15849 (69.5%) missing values	Missing
`SEXO` has 15849 (69.5%) missing values	Missing
`FECHA_DE_NACIMIENTO` has 15849 (69.5%) missing values	Missing
`RAZON_SOCIAL` has 6939 (30.5%) missing values	Missing
`NOMBRE_COMERCIAL` has 6939 (30.5%) missing values	Missing
`DELEGACION_MUNICIPIO` has 22033 (96.7%) missing values	Missing
`ENTIDAD_FEDERATIVA` has 22033 (96.7%) missing values	Missing
`VALOR_CUOTA` has 234 (1.0%) missing values	Missing
`CANTIDAD_CUOTAS_PAGADAS` has 257 (1.1%) missing values	Missing
`NO_EMPLEADOS` is highly skewed (γ1 = 31.64203232)	Skewed
`VENTAS_NETAS` is highly skewed (γ1 = 58.25274773)	Skewed
`AÑO_VENCIMIENTO` is highly skewed (γ1 = 39.37348963)	Skewed
`MONTO_APROBADO` is highly skewed (γ1 = 76.07952098)	Skewed
`MONTO_DISPONIBLE` is highly skewed (γ1 = 66.25622934)	Skewed
`MONTO_INICIAL` is highly skewed (γ1 = 97.26062948)	Skewed
`VALOR_CUOTA` is highly skewed (γ1 = 139.5894675)	Skewed
`MONTO_DISPONIBLE` has 21570 (94.7%) zeros	Zeros
`VALOR_CUOTA` has 299 (1.3%) zeros	Zeros
`CANTIDAD_CUOTAS_PAGADAS` has 16848 (73.9%) zeros	Zeros

Reproduction

Analysis started	2025-02-11 16:41:19.807582
Analysis finished	2025-02-11 16:42:12.537498
Duration	52.73 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

CODIGO_CLIENTE
Real number (ℝ)

High correlation

Distinct	5000
Distinct (%)	21.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21271267

Minimum	63041
Maximum	28958014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	63041
5-th percentile	3912887
Q1	11166973
median	28278053
Q3	28778209
95-th percentile	28920410
Maximum	28958014
Range	28894973
Interquartile range (IQR)	17611236

Descriptive statistics

Standard deviation	10116601
Coefficient of variation (CV)	0.47559934
Kurtosis	-1.0423473
Mean	21271267
Median Absolute Deviation (MAD)	614362
Skewness	-0.84304581
Sum	4.8472964 × 10¹¹
Variance	1.0234561 × 10¹⁴
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21678811	781	3.4%
11873011	742	3.3%
5313244	698	3.1%
7663354	531	2.3%
28175306	490	2.2%
28803403	445	2.0%
28653245	374	1.6%
6005914	265	1.2%
14841326	235	1.0%
28183253	203	0.9%
Other values (4990)	18024	79.1%

Value	Count	Frequency (%)
63041	1	< 0.1%
99003	3	< 0.1%
123173	2	< 0.1%
128196	66	0.3%
137337	2	< 0.1%
203738	1	< 0.1%
335024	183	0.8%
367786	1	< 0.1%
397726	2	< 0.1%
419934	1	< 0.1%

Value	Count	Frequency (%)
28958014	3	< 0.1%
28951682	1	< 0.1%
28951280	1	< 0.1%
28951011	1	< 0.1%
28950852	1	< 0.1%
28950790	1	< 0.1%
28950781	1	< 0.1%
28950763	1	< 0.1%
28950674	1	< 0.1%
28950665	1	< 0.1%

CODIGO_TIPO_IDENTIFICACION
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	178.2 KiB

7	15849
5	6939

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	22788
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	7
2nd row	7
3rd row	7
4th row	7
5th row	7

Common Values

Value	Count	Frequency (%)
7	15849	69.5%
5	6939	30.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
7	15849	69.5%
5	6939	30.5%

Most occurring characters

Value	Count	Frequency (%)
7	15849	69.5%
5	6939	30.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	22788	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
7	15849	69.5%
5	6939	30.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	22788	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
7	15849	69.5%
5	6939	30.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	22788	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
7	15849	69.5%
5	6939	30.5%

NOMBRES
Text

Missing

Distinct	1799
Distinct (%)	25.9%
Missing	15849
Missing (%)	69.5%
Memory size	178.2 KiB

Length

Max length	25
Median length	21
Mean length	10.020608
Min length	3

Characters and Unicode

Total characters	69533
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1139 ?
Unique (%)	16.4%

Sample

1st row	ISIDRO ERNESTO
2nd row	JESUS
3rd row	JESUS
4th row	JESUS
5th row	JESUS

Value	Count	Frequency (%)
jose	380	3.5%
maria	361	3.3%
manuel	269	2.5%
martha	244	2.2%
martin	234	2.1%
ofelia	207	1.9%
jesus	202	1.8%
juan	193	1.8%
victor	170	1.6%
antonio	170	1.6%
Other values (975)	8531	77.8%

Most occurring characters

Value	Count	Frequency (%)
A	11167	16.1%
E	6480	9.3%
R	6190	8.9%
I	5470	7.9%
O	5319	7.6%
N	4571	6.6%
L	4379	6.3%
	4043	5.8%
S	2662	3.8%
M	2597	3.7%
Other values (18)	16655	24.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	69533	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	11167	16.1%
E	6480	9.3%
R	6190	8.9%
I	5470	7.9%
O	5319	7.6%
N	4571	6.6%
L	4379	6.3%
	4043	5.8%
S	2662	3.8%
M	2597	3.7%
Other values (18)	16655	24.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	69533	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	11167	16.1%
E	6480	9.3%
R	6190	8.9%
I	5470	7.9%
O	5319	7.6%
N	4571	6.6%
L	4379	6.3%
	4043	5.8%
S	2662	3.8%
M	2597	3.7%
Other values (18)	16655	24.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	69533	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	11167	16.1%
E	6480	9.3%
R	6190	8.9%
I	5470	7.9%
O	5319	7.6%
N	4571	6.6%
L	4379	6.3%
	4043	5.8%
S	2662	3.8%
M	2597	3.7%
Other values (18)	16655	24.0%

PRIMER_APELLIDO
Text

Missing

Distinct	989
Distinct (%)	14.3%
Missing	15849
Missing (%)	69.5%
Memory size	178.2 KiB

Length

Max length	19
Median length	12
Mean length	6.5631935
Min length	2

Characters and Unicode

Total characters	45542
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	459 ?
Unique (%)	6.6%

Sample

1st row	CONDE
2nd row	GONZALEZ
3rd row	GONZALEZ
4th row	GONZALEZ
5th row	GONZALEZ

Value	Count	Frequency (%)
felix	323	4.6%
cortes	214	3.0%
rodriguez	211	3.0%
gonzalez	199	2.8%
lopez	183	2.6%
silva	157	2.2%
garcia	133	1.9%
martinez	133	1.9%
hernandez	110	1.6%
robles	105	1.5%
Other values (968)	5304	75.0%

Most occurring characters

Value	Count	Frequency (%)
A	6174	13.6%
E	5134	11.3%
R	4602	10.1%
O	3784	8.3%
L	3059	6.7%
I	2686	5.9%
Z	2548	5.6%
N	2411	5.3%
S	2340	5.1%
C	1732	3.8%
Other values (17)	11072	24.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	45542	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	6174	13.6%
E	5134	11.3%
R	4602	10.1%
O	3784	8.3%
L	3059	6.7%
I	2686	5.9%
Z	2548	5.6%
N	2411	5.3%
S	2340	5.1%
C	1732	3.8%
Other values (17)	11072	24.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	45542	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	6174	13.6%
E	5134	11.3%
R	4602	10.1%
O	3784	8.3%
L	3059	6.7%
I	2686	5.9%
Z	2548	5.6%
N	2411	5.3%
S	2340	5.1%
C	1732	3.8%
Other values (17)	11072	24.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	45542	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	6174	13.6%
E	5134	11.3%
R	4602	10.1%
O	3784	8.3%
L	3059	6.7%
I	2686	5.9%
Z	2548	5.6%
N	2411	5.3%
S	2340	5.1%
C	1732	3.8%
Other values (17)	11072	24.3%

SEGUNDO_APELLIDO
Text

Missing

Distinct	999
Distinct (%)	14.4%
Missing	15849
Missing (%)	69.5%
Memory size	178.2 KiB

Length

Max length	18
Median length	16
Mean length	6.5959072
Min length	1

Characters and Unicode

Total characters	45769
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	471 ?
Unique (%)	6.8%

Sample

1st row	CORONADO
2nd row	VAZQUEZ
3rd row	VAZQUEZ
4th row	VAZQUEZ
5th row	VAZQUEZ

Value	Count	Frequency (%)
garcia	370	5.2%
hernandez	351	5.0%
gomez	234	3.3%
rodriguez	201	2.8%
alcaraz	149	2.1%
gonzalez	141	2.0%
martinez	137	1.9%
rivas	122	1.7%
lopez	113	1.6%
cruz	103	1.5%
Other values (975)	5138	72.8%

Most occurring characters

Value	Count	Frequency (%)
A	6960	15.2%
E	5062	11.1%
R	5014	11.0%
O	3434	7.5%
Z	2880	6.3%
I	2655	5.8%
N	2630	5.7%
L	2367	5.2%
S	2070	4.5%
G	1731	3.8%
Other values (25)	10966	24.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	45769	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	6960	15.2%
E	5062	11.1%
R	5014	11.0%
O	3434	7.5%
Z	2880	6.3%
I	2655	5.8%
N	2630	5.7%
L	2367	5.2%
S	2070	4.5%
G	1731	3.8%
Other values (25)	10966	24.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	45769	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	6960	15.2%
E	5062	11.1%
R	5014	11.0%
O	3434	7.5%
Z	2880	6.3%
I	2655	5.8%
N	2630	5.7%
L	2367	5.2%
S	2070	4.5%
G	1731	3.8%
Other values (25)	10966	24.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	45769	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	6960	15.2%
E	5062	11.1%
R	5014	11.0%
O	3434	7.5%
Z	2880	6.3%
I	2655	5.8%
N	2630	5.7%
L	2367	5.2%
S	2070	4.5%
G	1731	3.8%
Other values (25)	10966	24.0%

SEXO
Categorical

High correlation Missing

Distinct	2
Distinct (%)	< 0.1%
Missing	15849
Missing (%)	69.5%
Memory size	178.2 KiB

M	4102
F	2837

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	6939
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	M
3rd row	M
4th row	M
5th row	M

Common Values

Value	Count	Frequency (%)
M	4102	18.0%
F	2837	12.4%
(Missing)	15849	69.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
m	4102	59.1%
f	2837	40.9%

Most occurring characters

Value	Count	Frequency (%)
M	4102	59.1%
F	2837	40.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6939	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	4102	59.1%
F	2837	40.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6939	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	4102	59.1%
F	2837	40.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6939	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	4102	59.1%
F	2837	40.9%

FECHA_DE_NACIMIENTO
Date

Missing

Distinct	2845
Distinct (%)	41.0%
Missing	15849
Missing (%)	69.5%
Memory size	178.2 KiB

Minimum	1936-05-13 00:00:00
Maximum	2004-10-24 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

RAZON_SOCIAL
Text

Missing

Distinct	1845
Distinct (%)	11.6%
Missing	6939
Missing (%)	30.5%
Memory size	178.2 KiB

Length

Max length	84
Median length	61
Mean length	33.841504
Min length	8

Characters and Unicode

Total characters	536354
Distinct characters	80
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	898 ?
Unique (%)	5.7%

Sample

1st row	LAMINA DESPLEGADA SA DE CV
2nd row	CAFE EL MARINO
3rd row	CAFE EL MARINO
4th row	CAFE EL MARINO
5th row	SCHETTINO HERMANOS, S. DE R.L. DE C.V.

Value	Count	Frequency (%)
de	17233	18.4%
cv	6862	7.3%
sa	6490	6.9%
c.v	5928	6.3%
s.a	5038	5.4%
y	1912	2.0%
mexico	1889	2.0%
s	1878	2.0%
del	1791	1.9%
sofom	1280	1.4%
Other values (2805)	43548	46.4%

Most occurring characters

Value	Count	Frequency (%)
	79479	14.8%
E	53423	10.0%
A	46968	8.8%
S	39624	7.4%
C	33442	6.2%
.	31485	5.9%
O	29938	5.6%
R	29787	5.6%
I	28745	5.4%
D	27533	5.1%
Other values (70)	135930	25.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	536354	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	79479	14.8%
E	53423	10.0%
A	46968	8.8%
S	39624	7.4%
C	33442	6.2%
.	31485	5.9%
O	29938	5.6%
R	29787	5.6%
I	28745	5.4%
D	27533	5.1%
Other values (70)	135930	25.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	536354	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	79479	14.8%
E	53423	10.0%
A	46968	8.8%
S	39624	7.4%
C	33442	6.2%
.	31485	5.9%
O	29938	5.6%
R	29787	5.6%
I	28745	5.4%
D	27533	5.1%
Other values (70)	135930	25.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	536354	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	79479	14.8%
E	53423	10.0%
A	46968	8.8%
S	39624	7.4%
C	33442	6.2%
.	31485	5.9%
O	29938	5.6%
R	29787	5.6%
I	28745	5.4%
D	27533	5.1%
Other values (70)	135930	25.3%

NOMBRE_COMERCIAL
Text

Missing

Distinct	1845
Distinct (%)	11.6%
Missing	6939
Missing (%)	30.5%
Memory size	178.2 KiB

Length

Max length	117
Median length	61
Mean length	31.100259
Min length	5

Characters and Unicode

Total characters	492908
Distinct characters	80
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	898 ?
Unique (%)	5.7%

Sample

1st row	LAMINA DESPLEGADA SA DE CV
2nd row	CAFE EL MARINO
3rd row	CAFE EL MARINO
4th row	CAFE EL MARINO
5th row	SCHETTINO HERMANOS, S. DE R.L. DE C.V.

Value	Count	Frequency (%)
de	14866	17.6%
cv	5680	6.7%
sa	5582	6.6%
c.v	4836	5.7%
s.a	4293	5.1%
y	1906	2.3%
mexico	1890	2.2%
del	1803	2.1%
s	1788	2.1%
r.l	1004	1.2%
Other values (2798)	40906	48.4%

Most occurring characters

Value	Count	Frequency (%)
	69962	14.2%
E	50017	10.1%
A	44770	9.1%
S	35982	7.3%
C	31277	6.3%
R	28653	5.8%
I	28295	5.7%
O	27705	5.6%
D	25219	5.1%
.	23755	4.8%
Other values (70)	127273	25.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	492908	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	69962	14.2%
E	50017	10.1%
A	44770	9.1%
S	35982	7.3%
C	31277	6.3%
R	28653	5.8%
I	28295	5.7%
O	27705	5.6%
D	25219	5.1%
.	23755	4.8%
Other values (70)	127273	25.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	492908	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	69962	14.2%
E	50017	10.1%
A	44770	9.1%
S	35982	7.3%
C	31277	6.3%
R	28653	5.8%
I	28295	5.7%
O	27705	5.6%
D	25219	5.1%
.	23755	4.8%
Other values (70)	127273	25.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	492908	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	69962	14.2%
E	50017	10.1%
A	44770	9.1%
S	35982	7.3%
C	31277	6.3%
R	28653	5.8%
I	28295	5.7%
O	27705	5.6%
D	25219	5.1%
.	23755	4.8%
Other values (70)	127273	25.8%

NO_EMPLEADOS
Real number (ℝ)

High correlation Skewed

Distinct	301
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	281.65451

Minimum	0
Maximum	130000
Zeros	141
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5
median	20
Q3	80
95-th percentile	850
Maximum	130000
Range	130000
Interquartile range (IQR)	75

Descriptive statistics

Standard deviation	2872.6355
Coefficient of variation (CV)	10.199146
Kurtosis	1168.5826
Mean	281.65451
Median Absolute Deviation (MAD)	19
Skewness	31.642032
Sum	6418343
Variance	8252034.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	4273	18.8%
500	1545	6.8%
10	1542	6.8%
5	1297	5.7%
20	950	4.2%
50	770	3.4%
354	769	3.4%
1270	742	3.3%
15	586	2.6%
8	507	2.2%
Other values (291)	9807	43.0%

Value	Count	Frequency (%)
0	141	0.6%
1	4273	18.8%
2	263	1.2%
3	503	2.2%
4	185	0.8%
5	1297	5.7%
6	328	1.4%
7	351	1.5%
8	507	2.2%
9	252	1.1%

Value	Count	Frequency (%)
130000	1	< 0.1%
128475	1	< 0.1%
120800	3	< 0.1%
93184	8	< 0.1%
42000	3	< 0.1%
32347	17	0.1%
26064	17	0.1%
22241	1	< 0.1%
15000	4	< 0.1%
14000	8	< 0.1%

VENTAS_NETAS
Real number (ℝ)

High correlation Skewed

Distinct	1274
Distinct (%)	5.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.2019786 × 10⁹

Minimum	0
Maximum	1.6308529 × 10¹²
Zeros	141
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	0
5-th percentile	5001
Q1	113892
median	9000507
Q3	93285120
95-th percentile	4.187462 × 10⁹
Maximum	1.6308529 × 10¹²
Range	1.6308529 × 10¹²
Interquartile range (IQR)	93171228

Descriptive statistics

Standard deviation	2.2504494 × 10¹⁰
Coefficient of variation (CV)	18.722874
Kurtosis	3851.8161
Mean	1.2019786 × 10⁹
Median Absolute Deviation (MAD)	8995506
Skewness	58.252748
Sum	2.7390688 × 10¹³
Variance	5.0645225 × 10²⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5001	3452	15.1%
50000	1206	5.3%
9892253586	742	3.3%
4187462000	698	3.1%
150000	556	2.4%
29106853	531	2.3%
93285120	445	2.0%
5000	423	1.9%
121456183	374	1.6%
581556532.1	265	1.2%
Other values (1264)	14096	61.9%

Value	Count	Frequency (%)
0	141	0.6%
1	102	0.4%
100	2	< 0.1%
1800	2	< 0.1%
2812.57	19	0.1%
5000	423	1.9%
5001	3452	15.1%
5500	7	< 0.1%
7000	1	< 0.1%
7500	1	< 0.1%

Value	Count	Frequency (%)
1.63085289 × 10¹²	3	< 0.1%
6.43404732 × 10¹¹	8	< 0.1%
1.96607 × 10¹¹	3	< 0.1%
4.62487704 × 10¹⁰	1	< 0.1%
3.965681318 × 10¹⁰	16	0.1%
3.55850007 × 10¹⁰	1	< 0.1%
3.3430939 × 10¹⁰	2	< 0.1%
3.1133 × 10¹⁰	9	< 0.1%
3.10379058 × 10¹⁰	17	0.1%
2.778811182 × 10¹⁰	1	< 0.1%

PAIS
Categorical

High correlation Imbalance

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	178.2 KiB

MEXICO	22785
ALEMANIA	2
ESTADOS UNIDOS	1

Length

Max length	14
Median length	6
Mean length	6.0005266
Min length	6

Characters and Unicode

Total characters	136740
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	MEXICO
2nd row	MEXICO
3rd row	MEXICO
4th row	MEXICO
5th row	MEXICO

Common Values

Value	Count	Frequency (%)
MEXICO	22785	> 99.9%
ALEMANIA	2	< 0.1%
ESTADOS UNIDOS	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mexico	22785	> 99.9%
alemania	2	< 0.1%
estados	1	< 0.1%
unidos	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
E	22788	16.7%
I	22788	16.7%
M	22787	16.7%
O	22787	16.7%
X	22785	16.7%
C	22785	16.7%
A	7	< 0.1%
N	3	< 0.1%
S	3	< 0.1%
L	2	< 0.1%
Other values (4)	5	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	136740	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	22788	16.7%
I	22788	16.7%
M	22787	16.7%
O	22787	16.7%
X	22785	16.7%
C	22785	16.7%
A	7	< 0.1%
N	3	< 0.1%
S	3	< 0.1%
L	2	< 0.1%
Other values (4)	5	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	136740	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	22788	16.7%
I	22788	16.7%
M	22787	16.7%
O	22787	16.7%
X	22785	16.7%
C	22785	16.7%
A	7	< 0.1%
N	3	< 0.1%
S	3	< 0.1%
L	2	< 0.1%
Other values (4)	5	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	136740	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	22788	16.7%
I	22788	16.7%
M	22787	16.7%
O	22787	16.7%
X	22785	16.7%
C	22785	16.7%
A	7	< 0.1%
N	3	< 0.1%
S	3	< 0.1%
L	2	< 0.1%
Other values (4)	5	< 0.1%

NACIONALIDAD
Categorical

High correlation Imbalance

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	178.2 KiB

MEXICANA	22785
ALEMANA	2
ESTADOUNIDENSE	1

Length

Max length	14
Median length	8
Mean length	8.0001755
Min length	7

Characters and Unicode

Total characters	182308
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	MEXICANA
2nd row	MEXICANA
3rd row	MEXICANA
4th row	MEXICANA
5th row	MEXICANA

Common Values

Value	Count	Frequency (%)
MEXICANA	22785	> 99.9%
ALEMANA	2	< 0.1%
ESTADOUNIDENSE	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mexicana	22785	> 99.9%
alemana	2	< 0.1%
estadounidense	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	45577	25.0%
E	22790	12.5%
N	22789	12.5%
M	22787	12.5%
I	22786	12.5%
X	22785	12.5%
C	22785	12.5%
L	2	< 0.1%
S	2	< 0.1%
D	2	< 0.1%
Other values (3)	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	182308	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	45577	25.0%
E	22790	12.5%
N	22789	12.5%
M	22787	12.5%
I	22786	12.5%
X	22785	12.5%
C	22785	12.5%
L	2	< 0.1%
S	2	< 0.1%
D	2	< 0.1%
Other values (3)	3	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	182308	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	45577	25.0%
E	22790	12.5%
N	22789	12.5%
M	22787	12.5%
I	22786	12.5%
X	22785	12.5%
C	22785	12.5%
L	2	< 0.1%
S	2	< 0.1%
D	2	< 0.1%
Other values (3)	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	182308	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	45577	25.0%
E	22790	12.5%
N	22789	12.5%
M	22787	12.5%
I	22786	12.5%
X	22785	12.5%
C	22785	12.5%
L	2	< 0.1%
S	2	< 0.1%
D	2	< 0.1%
Other values (3)	3	< 0.1%

DELEGACION_MUNICIPIO
Categorical

High correlation Missing

Distinct	38
Distinct (%)	5.0%
Missing	22033
Missing (%)	96.7%
Memory size	178.2 KiB

MONTERREY	334
CULIACAN	115
SAN LUIS POTOSI	66
PARRAS DE LA FUENTE	38
ISLA MUJERES	37
Other values (33)	165

Length

Max length	28
Median length	26
Mean length	10.2
Min length	4

Characters and Unicode

Total characters	7701
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	13 ?
Unique (%)	1.7%

Sample

1st row	SANTA CATARINA LA FAMA
2nd row	MAZATLAN
3rd row	MAZATLAN
4th row	MAZATLAN
5th row	ORIZABA

Common Values

Value	Count	Frequency (%)
MONTERREY	334	1.5%
CULIACAN	115	0.5%
SAN LUIS POTOSI	66	0.3%
PARRAS DE LA FUENTE	38	0.2%
ISLA MUJERES	37	0.2%
VERACRUZ	34	0.1%
TORREON	32	0.1%
GUADALAJARA	23	0.1%
IZTACALCO	13	0.1%
SALTO EL	7	< 0.1%
Other values (28)	56	0.2%
(Missing)	22033	96.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
monterrey	334	30.6%
culiacan	115	10.5%
san	67	6.1%
luis	66	6.0%
potosi	66	6.0%
de	47	4.3%
la	39	3.6%
parras	38	3.5%
fuente	38	3.5%
mujeres	37	3.4%
Other values (48)	246	22.5%

Most occurring characters

Value	Count	Frequency (%)
E	986	12.8%
R	972	12.6%
A	746	9.7%
N	625	8.1%
O	607	7.9%
T	513	6.7%
M	390	5.1%
L	359	4.7%
U	351	4.6%
S	339	4.4%
Other values (17)	1813	23.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7701	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	986	12.8%
R	972	12.6%
A	746	9.7%
N	625	8.1%
O	607	7.9%
T	513	6.7%
M	390	5.1%
L	359	4.7%
U	351	4.6%
S	339	4.4%
Other values (17)	1813	23.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7701	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	986	12.8%
R	972	12.6%
A	746	9.7%
N	625	8.1%
O	607	7.9%
T	513	6.7%
M	390	5.1%
L	359	4.7%
U	351	4.6%
S	339	4.4%
Other values (17)	1813	23.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7701	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	986	12.8%
R	972	12.6%
A	746	9.7%
N	625	8.1%
O	607	7.9%
T	513	6.7%
M	390	5.1%
L	359	4.7%
U	351	4.6%
S	339	4.4%
Other values (17)	1813	23.5%

ENTIDAD_FEDERATIVA
Categorical

High correlation Missing

Distinct	21
Distinct (%)	2.8%
Missing	22033
Missing (%)	96.7%
Memory size	178.2 KiB

NUEVO LEON	341
SINALOA	119
COAHUILA DE ZARAGOZA	70
SAN LUIS POTOSI	66
JALISCO	40
Other values (16)	119

Length

Max length	20
Median length	19
Mean length	10.85298
Min length	6

Characters and Unicode

Total characters	8194
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	0.8%

Sample

1st row	NUEVO LEON
2nd row	SINALOA
3rd row	SINALOA
4th row	SINALOA
5th row	VERACRUZ

Common Values

Value	Count	Frequency (%)
NUEVO LEON	341	1.5%
SINALOA	119	0.5%
COAHUILA DE ZARAGOZA	70	0.3%
SAN LUIS POTOSI	66	0.3%
JALISCO	40	0.2%
QUINTANA ROO	37	0.2%
VERACRUZ	36	0.2%
CIUDAD DE MEXICO	21	0.1%
GUANAJUATO	4	< 0.1%
MEXICO	3	< 0.1%
Other values (11)	18	0.1%
(Missing)	22033	96.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nuevo	341	23.5%
leon	341	23.5%
sinaloa	119	8.2%
de	92	6.3%
coahuila	70	4.8%
zaragoza	70	4.8%
san	66	4.6%
luis	66	4.6%
potosi	66	4.6%
jalisco	40	2.8%
Other values (19)	179	12.3%

Most occurring characters

Value	Count	Frequency (%)
O	1227	15.0%
N	952	11.6%
A	872	10.6%
E	841	10.3%
	695	8.5%
L	639	7.8%
U	593	7.2%
I	452	5.5%
V	377	4.6%
S	358	4.4%
Other values (15)	1188	14.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8194	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
O	1227	15.0%
N	952	11.6%
A	872	10.6%
E	841	10.3%
	695	8.5%
L	639	7.8%
U	593	7.2%
I	452	5.5%
V	377	4.6%
S	358	4.4%
Other values (15)	1188	14.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8194	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
O	1227	15.0%
N	952	11.6%
A	872	10.6%
E	841	10.3%
	695	8.5%
L	639	7.8%
U	593	7.2%
I	452	5.5%
V	377	4.6%
S	358	4.4%
Other values (15)	1188	14.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8194	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
O	1227	15.0%
N	952	11.6%
A	872	10.6%
E	841	10.3%
	695	8.5%
L	639	7.8%
U	593	7.2%
I	452	5.5%
V	377	4.6%
S	358	4.4%
Other values (15)	1188	14.5%

TIPO_SECTOR
Categorical

High correlation

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	178.2 KiB

INDUSTRIAS MANUFACTURERAS	9539
COMERCIO	6168
SERVICIOS COMUNALES Y SOCIALES (HOTELES Y RESTAURANTES)	2095
SERVICIOS FINANCIEROS, DE ADMON Y ALQUILER DE BIENES MUEBLES	1924
TRANSPORTES Y COMUNICACIONES	1840
Other values (3)	1222

Length

Max length	60
Median length	55
Mean length	25.769089
Min length	8

Characters and Unicode

Total characters	587226
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	INDUSTRIAS MANUFACTURERAS
2nd row	INDUSTRIAS MANUFACTURERAS
3rd row	INDUSTRIAS MANUFACTURERAS
4th row	INDUSTRIAS MANUFACTURERAS
5th row	COMERCIO

Common Values

Value	Count	Frequency (%)
INDUSTRIAS MANUFACTURERAS	9539	41.9%
COMERCIO	6168	27.1%
SERVICIOS COMUNALES Y SOCIALES (HOTELES Y RESTAURANTES)	2095	9.2%
SERVICIOS FINANCIEROS, DE ADMON Y ALQUILER DE BIENES MUEBLES	1924	8.4%
TRANSPORTES Y COMUNICACIONES	1840	8.1%
CONSTRUCCION	1059	4.6%
MINERIA Y EXTRACCION DE PETROLEO	109	0.5%
ELECTRICIDAD Y AGUA	54	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
industrias	9539	14.8%
manufactureras	9539	14.8%
y	8117	12.6%
comercio	6168	9.6%
servicios	4019	6.2%
de	3957	6.1%
comunales	2095	3.2%
sociales	2095	3.2%
hoteles	2095	3.2%
restaurantes	2095	3.2%
Other values (13)	14794	22.9%

Most occurring characters

Value	Count	Frequency (%)
S	61576	10.5%
A	56368	9.6%
E	52021	8.9%
R	51962	8.8%
I	48249	8.2%
	41725	7.1%
C	41031	7.0%
U	39608	6.7%
N	38820	6.6%
O	34453	5.9%
Other values (16)	121413	20.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	587226	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
S	61576	10.5%
A	56368	9.6%
E	52021	8.9%
R	51962	8.8%
I	48249	8.2%
	41725	7.1%
C	41031	7.0%
U	39608	6.7%
N	38820	6.6%
O	34453	5.9%
Other values (16)	121413	20.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	587226	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
S	61576	10.5%
A	56368	9.6%
E	52021	8.9%
R	51962	8.8%
I	48249	8.2%
	41725	7.1%
C	41031	7.0%
U	39608	6.7%
N	38820	6.6%
O	34453	5.9%
Other values (16)	121413	20.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	587226	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
S	61576	10.5%
A	56368	9.6%
E	52021	8.9%
R	51962	8.8%
I	48249	8.2%
	41725	7.1%
C	41031	7.0%
U	39608	6.7%
N	38820	6.6%
O	34453	5.9%
Other values (16)	121413	20.7%

TIPO_SUBSECTOR
Categorical

High correlation

Distinct	29
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	178.2 KiB

COMERCIO AL POR MAYOR	4438
PRODUCTOS METALICOS ,MAQUINARIA Y EQUIPO.(I) INSTRUMENTOS Q	3874
PRODUCTOS ALIMENTICIOS, BEBIDAS Y TABACO	2692
TRANSPORTE FERROVIARIO, METRO, TRANVIAS Y TROLEBUSES	1819
SERVICIOS FINANCIEROS DE SEGUROS Y FINANZAS	1708
Other values (24)	8257

Length

Max length	60
Median length	58
Mean length	38.843909
Min length	12

Characters and Unicode

Total characters	885175
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	INDUSTRIAS METALICAS BASICAS
2nd row	PRODUCTOS ALIMENTICIOS, BEBIDAS Y TABACO
3rd row	PRODUCTOS ALIMENTICIOS, BEBIDAS Y TABACO
4th row	PRODUCTOS ALIMENTICIOS, BEBIDAS Y TABACO
5th row	COMERCIO AL POR MAYOR

Common Values

Value	Count	Frequency (%)
COMERCIO AL POR MAYOR	4438	19.5%
PRODUCTOS METALICOS ,MAQUINARIA Y EQUIPO.(I) INSTRUMENTOS Q	3874	17.0%
PRODUCTOS ALIMENTICIOS, BEBIDAS Y TABACO	2692	11.8%
TRANSPORTE FERROVIARIO, METRO, TRANVIAS Y TROLEBUSES	1819	8.0%
SERVICIOS FINANCIEROS DE SEGUROS Y FINANZAS	1708	7.5%
COMERCIO AL POR MENOR	1575	6.9%
CONSTRUCCION	1059	4.6%
OTRAS INDUSTRIAS MANUFACTURERAS	1007	4.4%
SERVICIOS DE REPARACION Y MANTENIMIENTO	919	4.0%
SERVICIOS PROFESIONALES, TECNICOS ESPECIALIZAOS	873	3.8%
Other values (19)	2824	12.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
y	13279	11.3%
productos	7887	6.7%
comercio	6013	5.1%
por	6013	5.1%
al	6013	5.1%
de	5432	4.6%
mayor	4438	3.8%
metalicos	4045	3.4%
maquinaria	3874	3.3%
equipo.(i	3874	3.3%
Other values (81)	56695	48.2%

Most occurring characters

Value	Count	Frequency (%)
	94775	10.7%
O	86173	9.7%
I	77029	8.7%
R	69908	7.9%
A	69100	7.8%
E	67483	7.6%
S	64275	7.3%
T	47078	5.3%
C	45863	5.2%
N	40889	4.6%
Other values (18)	222602	25.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	885175	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	94775	10.7%
O	86173	9.7%
I	77029	8.7%
R	69908	7.9%
A	69100	7.8%
E	67483	7.6%
S	64275	7.3%
T	47078	5.3%
C	45863	5.2%
N	40889	4.6%
Other values (18)	222602	25.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	885175	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	94775	10.7%
O	86173	9.7%
I	77029	8.7%
R	69908	7.9%
A	69100	7.8%
E	67483	7.6%
S	64275	7.3%
T	47078	5.3%
C	45863	5.2%
N	40889	4.6%
Other values (18)	222602	25.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	885175	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	94775	10.7%
O	86173	9.7%
I	77029	8.7%
R	69908	7.9%
A	69100	7.8%
E	67483	7.6%
S	64275	7.3%
T	47078	5.3%
C	45863	5.2%
N	40889	4.6%
Other values (18)	222602	25.1%

TIPO_RAMA
Text

Distinct	90
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	178.2 KiB

Length

Max length	60
Median length	59
Mean length	48.957785
Min length	11

Characters and Unicode

Total characters	1115650
Distinct characters	31
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	< 0.1%

Sample

1st row	INDUSTRIAS BASICAS DE METALES NO FERROSOS. (I) EL TRATAMIENT
2nd row	BENEFICIO Y MOLIENDA DE CEREALES Y OTROS PRODUCTOS AGRICOLAS
3rd row	BENEFICIO Y MOLIENDA DE CEREALES Y OTROS PRODUCTOS AGRICOLAS
4th row	BENEFICIO Y MOLIENDA DE CEREALES Y OTROS PRODUCTOS AGRICOLAS
5th row	COMERCIO DE PRODUCTOS ALIMENTICIOS, BEBIDAS Y TABACO AL POR

Value	Count	Frequency (%)
de	22004	13.8%
y	10839	6.8%
productos	8805	5.5%
alimenticios	6682	4.2%
por	6349	4.0%
comercio	5938	3.7%
al	5937	3.7%
reparacion	4566	2.9%
maquinaria	4352	2.7%
fabricacion	4301	2.7%
Other values (213)	79878	50.0%

Most occurring characters

Value	Count	Frequency (%)
	137991	12.4%
O	106238	9.5%
A	105808	9.5%
I	96030	8.6%
E	95525	8.6%
R	75952	6.8%
C	70732	6.3%
S	62418	5.6%
N	60677	5.4%
T	38206	3.4%
Other values (21)	266073	23.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1115650	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	137991	12.4%
O	106238	9.5%
A	105808	9.5%
I	96030	8.6%
E	95525	8.6%
R	75952	6.8%
C	70732	6.3%
S	62418	5.6%
N	60677	5.4%
T	38206	3.4%
Other values (21)	266073	23.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1115650	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	137991	12.4%
O	106238	9.5%
A	105808	9.5%
I	96030	8.6%
E	95525	8.6%
R	75952	6.8%
C	70732	6.3%
S	62418	5.6%
N	60677	5.4%
T	38206	3.4%
Other values (21)	266073	23.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1115650	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	137991	12.4%
O	106238	9.5%
A	105808	9.5%
I	96030	8.6%
E	95525	8.6%
R	75952	6.8%
C	70732	6.3%
S	62418	5.6%
N	60677	5.4%
T	38206	3.4%
Other values (21)	266073	23.8%

TIPO_CLASE
Text

Distinct	304
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	178.2 KiB

Length

Max length	60
Median length	60
Mean length	56.375066
Min length	5

Characters and Unicode

Total characters	1284675
Distinct characters	36
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	43 ?
Unique (%)	0.2%

Sample

1st row	FUNDICION, LAMINACION, EXTRUSION, REFINACION Y/O ESTIRAJE DE
2nd row	BENEFICIO DE CAFE
3rd row	BENEFICIO DE CAFE
4th row	BENEFICIO DE CAFE
5th row	CHILE SECO Y ESPECIAS (I) PASTA PARA MOLE Y SIMILARES

Value	Count	Frequency (%)
de	28728	14.9%
y	15652	8.1%
i	8999	4.7%
fabricacion	5387	2.8%
ref	4276	2.2%
aparatos	3499	1.8%
equipos	3454	1.8%
aire	3453	1.8%
acondicionado	3453	1.8%
no	3087	1.6%
Other values (784)	112311	58.4%

Most occurring characters

Value	Count	Frequency (%)
	170197	13.2%
A	133794	10.4%
E	119477	9.3%
O	109405	8.5%
I	101190	7.9%
R	95668	7.4%
S	76778	6.0%
C	73025	5.7%
N	67393	5.2%
D	58044	4.5%
Other values (26)	279704	21.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1284675	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	170197	13.2%
A	133794	10.4%
E	119477	9.3%
O	109405	8.5%
I	101190	7.9%
R	95668	7.4%
S	76778	6.0%
C	73025	5.7%
N	67393	5.2%
D	58044	4.5%
Other values (26)	279704	21.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1284675	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	170197	13.2%
A	133794	10.4%
E	119477	9.3%
O	109405	8.5%
I	101190	7.9%
R	95668	7.4%
S	76778	6.0%
C	73025	5.7%
N	67393	5.2%
D	58044	4.5%
Other values (26)	279704	21.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1284675	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	170197	13.2%
A	133794	10.4%
E	119477	9.3%
O	109405	8.5%
I	101190	7.9%
R	95668	7.4%
S	76778	6.0%
C	73025	5.7%
N	67393	5.2%
D	58044	4.5%
Other values (26)	279704	21.8%

NUMERO_CONTRATO
Real number (ℝ)

High correlation

Distinct	22735
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	39518177

Minimum	5643752
Maximum	40709381
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	5643752
5-th percentile	34459794
Q1	40379620
median	40573686
Q3	40659959
95-th percentile	40700819
Maximum	40709381
Range	35065629
Interquartile range (IQR)	280339.75

Descriptive statistics

Standard deviation	2641404.1
Coefficient of variation (CV)	0.066840232
Kurtosis	26.954456
Mean	39518177
Median Absolute Deviation (MAD)	113362
Skewness	-4.1013988
Sum	9.0054022 × 10¹¹
Variance	6.9770157 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40709267	11	< 0.1%
40709252	5	< 0.1%
24231558	5	< 0.1%
35124289	5	< 0.1%
34170179	5	< 0.1%
34157967	4	< 0.1%
35199909	4	< 0.1%
40709255	4	< 0.1%
40705513	3	< 0.1%
34236669	3	< 0.1%
Other values (22725)	22739	99.8%

Value	Count	Frequency (%)
5643752	1	< 0.1%
7406253	1	< 0.1%
7870719	1	< 0.1%
7879529	1	< 0.1%
7879715	1	< 0.1%
8058557	1	< 0.1%
8098586	1	< 0.1%
8602707	1	< 0.1%
8622186	1	< 0.1%
8622187	1	< 0.1%

Value	Count	Frequency (%)
40709381	1	< 0.1%
40709380	1	< 0.1%
40709379	1	< 0.1%
40709378	1	< 0.1%
40709377	1	< 0.1%
40709376	1	< 0.1%
40709375	1	< 0.1%
40709374	1	< 0.1%
40709373	1	< 0.1%
40709372	1	< 0.1%

NUMERO_PRESTAMO
Real number (ℝ)

High correlation

Distinct	22584
Distinct (%)	100.0%
Missing	204
Missing (%)	0.9%
Infinite	0
Infinite (%)	0.0%
Mean	4.0925883 × 10⁸

Minimum	71740515
Maximum	4.2087615 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	71740515
5-th percentile	3.5894232 × 10⁸
Q1	4.1761063 × 10⁸
median	4.1953925 × 10⁸
Q3	4.2038686 × 10⁸
95-th percentile	4.2078765 × 10⁸
Maximum	4.2087615 × 10⁸
Range	3.4913563 × 10⁸
Interquartile range (IQR)	2776224.5

Descriptive statistics

Standard deviation	26146913
Coefficient of variation (CV)	0.063888452
Kurtosis	27.837987
Mean	4.0925883 × 10⁸
Median Absolute Deviation (MAD)	1109541
Skewness	-4.180004
Sum	9.2427014 × 10¹²
Variance	6.8366107 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
405327964	1	< 0.1%
420377346	1	< 0.1%
355828125	1	< 0.1%
359792148	1	< 0.1%
359792193	1	< 0.1%
420279587	1	< 0.1%
420265010	1	< 0.1%
420265243	1	< 0.1%
379031708	1	< 0.1%
420562556	1	< 0.1%
Other values (22574)	22574	99.1%
(Missing)	204	0.9%

Value	Count	Frequency (%)
71740515	1	< 0.1%
89357139	1	< 0.1%
93998091	1	< 0.1%
94086378	1	< 0.1%
94088303	1	< 0.1%
95876638	1	< 0.1%
96282778	1	< 0.1%
101313464	1	< 0.1%
101508094	1	< 0.1%
101508101	1	< 0.1%

Value	Count	Frequency (%)
420876146	1	< 0.1%
420876137	1	< 0.1%
420876128	1	< 0.1%
420876119	1	< 0.1%
420876100	1	< 0.1%
420876093	1	< 0.1%
420876084	1	< 0.1%
420876075	1	< 0.1%
420876066	1	< 0.1%
420876057	1	< 0.1%

FECHA_APERTURA
Date

Distinct	1141
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Memory size	178.2 KiB

Minimum	2007-04-24 00:00:00
Maximum	2025-01-28 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

AÑO_REGISTRO
Real number (ℝ)

High correlation

Distinct	19
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2023.4406

Minimum	2007
Maximum	2025
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	2007
5-th percentile	2021
Q1	2024
median	2024
Q3	2024
95-th percentile	2024
Maximum	2025
Range	18
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.4373069
Coefficient of variation (CV)	0.00071032819
Kurtosis	21.784156
Mean	2023.4406
Median Absolute Deviation (MAD)	0
Skewness	-3.9161485
Sum	46110164
Variance	2.0658511
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
2024	18206	79.9%
2022	1304	5.7%
2021	1264	5.5%
2023	1151	5.1%
2020	299	1.3%
2018	177	0.8%
2017	110	0.5%
2019	103	0.5%
2016	82	0.4%
2015	26	0.1%
Other values (9)	66	0.3%

Value	Count	Frequency (%)
2007	1	< 0.1%
2008	6	< 0.1%
2009	10	< 0.1%
2010	8	< 0.1%
2011	3	< 0.1%
2012	4	< 0.1%
2013	17	0.1%
2014	12	0.1%
2015	26	0.1%
2016	82	0.4%

Value	Count	Frequency (%)
2025	5	< 0.1%
2024	18206	79.9%
2023	1151	5.1%
2022	1304	5.7%
2021	1264	5.5%
2020	299	1.3%
2019	103	0.5%
2018	177	0.8%
2017	110	0.5%
2016	82	0.4%

MES_REGISTRO
Real number (ℝ)

High correlation

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.9525189

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	8
median	10
Q3	10
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.325327
Coefficient of variation (CV)	0.25973997
Kurtosis	2.7367869
Mean	8.9525189
Median Absolute Deviation (MAD)	1
Skewness	-1.7681332
Sum	204010
Variance	5.4071455
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
10	9082	39.9%
9	3929	17.2%
11	3430	15.1%
8	2280	10.0%
12	608	2.7%
6	574	2.5%
3	568	2.5%
7	553	2.4%
5	497	2.2%
4	454	2.0%
Other values (2)	813	3.6%

Value	Count	Frequency (%)
1	383	1.7%
2	430	1.9%
3	568	2.5%
4	454	2.0%
5	497	2.2%
6	574	2.5%
7	553	2.4%
8	2280	10.0%
9	3929	17.2%
10	9082	39.9%

Value	Count	Frequency (%)
12	608	2.7%
11	3430	15.1%
10	9082	39.9%
9	3929	17.2%
8	2280	10.0%
7	553	2.4%
6	574	2.5%
5	497	2.2%
4	454	2.0%
3	568	2.5%

DIA_REGISTRO
Real number (ℝ)

Distinct	31
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.4835

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	8
median	18
Q3	25
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	9.5216959
Coefficient of variation (CV)	0.57765013
Kurtosis	-1.2835406
Mean	16.4835
Median Absolute Deviation (MAD)	8
Skewness	-0.17917262
Sum	375626
Variance	90.662693
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	1661	7.3%
4	1588	7.0%
18	1285	5.6%
23	1261	5.5%
30	1248	5.5%
25	1064	4.7%
11	1060	4.7%
21	964	4.2%
28	940	4.1%
5	770	3.4%
Other values (21)	10947	48.0%

Value	Count	Frequency (%)
1	1661	7.3%
2	468	2.1%
3	384	1.7%
4	1588	7.0%
5	770	3.4%
6	345	1.5%
7	344	1.5%
8	269	1.2%
9	476	2.1%
10	698	3.1%

Value	Count	Frequency (%)
31	643	2.8%
30	1248	5.5%
29	632	2.8%
28	940	4.1%
27	743	3.3%
26	725	3.2%
25	1064	4.7%
24	670	2.9%
23	1261	5.5%
22	766	3.4%

FECHA_VENCIMIENTO
Text

Distinct	1117
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Memory size	178.2 KiB

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	432972
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	381 ?
Unique (%)	1.7%

Sample

1st row	2025-04-16 00:00:00
2nd row	2025-04-03 00:00:00
3rd row	2025-03-03 00:00:00
4th row	2025-02-17 00:00:00
5th row	2025-02-11 00:00:00

Value	Count	Frequency (%)
00:00:00	22788	50.0%
2025-03-04	2451	5.4%
2025-02-07	1303	2.9%
2025-02-11	950	2.1%
2025-02-13	913	2.0%
2025-02-26	879	1.9%
2025-02-17	831	1.8%
2025-02-20	827	1.8%
2025-02-24	715	1.6%
2025-03-06	625	1.4%
Other values (1108)	13294	29.2%

Most occurring characters

Value	Count	Frequency (%)
0	191152	44.1%
2	62047	14.3%
-	45576	10.5%
:	45576	10.5%
	22788	5.3%
5	19028	4.4%
1	14014	3.2%
3	10483	2.4%
7	6741	1.6%
4	6105	1.4%
Other values (3)	9462	2.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	432972	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	191152	44.1%
2	62047	14.3%
-	45576	10.5%
:	45576	10.5%
	22788	5.3%
5	19028	4.4%
1	14014	3.2%
3	10483	2.4%
7	6741	1.6%
4	6105	1.4%
Other values (3)	9462	2.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	432972	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	191152	44.1%
2	62047	14.3%
-	45576	10.5%
:	45576	10.5%
	22788	5.3%
5	19028	4.4%
1	14014	3.2%
3	10483	2.4%
7	6741	1.6%
4	6105	1.4%
Other values (3)	9462	2.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	432972	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	191152	44.1%
2	62047	14.3%
-	45576	10.5%
:	45576	10.5%
	22788	5.3%
5	19028	4.4%
1	14014	3.2%
3	10483	2.4%
7	6741	1.6%
4	6105	1.4%
Other values (3)	9462	2.2%

AÑO_VENCIMIENTO
Real number (ℝ)

High correlation Skewed

Distinct	21
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2025.7238

Minimum	2025
Maximum	2264
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	2025
5-th percentile	2025
Q1	2025
median	2025
Q3	2025
95-th percentile	2029
Maximum	2264
Range	239
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.5185768
Coefficient of variation (CV)	0.0012432972
Kurtosis	3525.5523
Mean	2025.7238
Median Absolute Deviation (MAD)	0
Skewness	39.37349
Sum	46162195
Variance	6.3432291
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
2025	17613	77.3%
2026	1569	6.9%
2027	1393	6.1%
2028	837	3.7%
2029	744	3.3%
2038	227	1.0%
2031	81	0.4%
2032	58	0.3%
2030	49	0.2%
2035	46	0.2%
Other values (11)	171	0.8%

Value	Count	Frequency (%)
2025	17613	77.3%
2026	1569	6.9%
2027	1393	6.1%
2028	837	3.7%
2029	744	3.3%
2030	49	0.2%
2031	81	0.4%
2032	58	0.3%
2033	37	0.2%
2034	36	0.2%

Value	Count	Frequency (%)
2264	1	< 0.1%
2056	3	< 0.1%
2049	2	< 0.1%
2045	2	< 0.1%
2043	1	< 0.1%
2041	1	< 0.1%
2039	7	< 0.1%
2038	227	1.0%
2037	42	0.2%
2036	39	0.2%

MES_VENCIMIENTO
Real number (ℝ)

High correlation

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.6045726

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	2
median	3
Q3	4
95-th percentile	10
Maximum	12
Range	11
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.5605907
Coefficient of variation (CV)	0.7103729
Kurtosis	2.7438479
Mean	3.6045726
Median Absolute Deviation (MAD)	1
Skewness	1.9242011
Sum	82141
Variance	6.5566245
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
2	9666	42.4%
3	6804	29.9%
4	1713	7.5%
9	619	2.7%
6	565	2.5%
5	532	2.3%
7	515	2.3%
12	504	2.2%
11	489	2.1%
8	470	2.1%
Other values (2)	911	4.0%

Value	Count	Frequency (%)
1	442	1.9%
2	9666	42.4%
3	6804	29.9%
4	1713	7.5%
5	532	2.3%
6	565	2.5%
7	515	2.3%
8	470	2.1%
9	619	2.7%
10	469	2.1%

Value	Count	Frequency (%)
12	504	2.2%
11	489	2.1%
10	469	2.1%
9	619	2.7%
8	470	2.1%
7	515	2.3%
6	565	2.5%
5	532	2.3%
4	1713	7.5%
3	6804	29.9%

DIA_VENCIMIENTO
Real number (ℝ)

High correlation

Distinct	31
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.57052

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	7
median	14
Q3	21
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	8.5831265
Coefficient of variation (CV)	0.58907484
Kurtosis	-1.1188373
Mean	14.57052
Median Absolute Deviation (MAD)	7
Skewness	0.22987536
Sum	332033
Variance	73.670061
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
4	2801	12.3%
17	2300	10.1%
7	1617	7.1%
13	1570	6.9%
10	1426	6.3%
20	1156	5.1%
11	1138	5.0%
29	1070	4.7%
26	978	4.3%
27	874	3.8%
Other values (21)	7858	34.5%

Value	Count	Frequency (%)
1	633	2.8%
2	108	0.5%
3	843	3.7%
4	2801	12.3%
5	129	0.6%
6	682	3.0%
7	1617	7.1%
8	60	0.3%
9	141	0.6%
10	1426	6.3%

Value	Count	Frequency (%)
31	334	1.5%
30	197	0.9%
29	1070	4.7%
28	457	2.0%
27	874	3.8%
26	978	4.3%
25	257	1.1%
24	869	3.8%
23	75	0.3%
22	73	0.3%

PRODUCTO
Categorical

High correlation Imbalance

Distinct	26
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	178.2 KiB

2DO. PISO, M.N. HABILITACION O AVIO	15438
CREDITO SIMPLE FIDE	3446
SIMPLE SIN GARANTIA REAL M.N.	1558
DESCUENTOS MONEDA NACIONAL	778
2DO. PISO, M.N. SIMPLE	399
Other values (21)	1169

Length

Max length	40
Median length	35
Mean length	31.232008
Min length	12

Characters and Unicode

Total characters	711715
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	2DO. PISO, M.N. SIMPLE
2nd row	2DO. PISO, M.N. HABILITACION O AVIO
3rd row	2DO. PISO, M.N. HABILITACION O AVIO
4th row	2DO. PISO, M.N. HABILITACION O AVIO
5th row	2DO. PISO, M.N. HABILITACION O AVIO

Common Values

Value	Count	Frequency (%)
2DO. PISO, M.N. HABILITACION O AVIO	15438	67.7%
CREDITO SIMPLE FIDE	3446	15.1%
SIMPLE SIN GARANTIA REAL M.N.	1558	6.8%
DESCUENTOS MONEDA NACIONAL	778	3.4%
2DO. PISO, M.N. SIMPLE	399	1.8%
2DO. PISO, DLLS. HABILITACION O AVIO	396	1.7%
SIMPLE SIN GARANTIA REAL DLS.	239	1.0%
MANDATOS DLLS.	217	1.0%
HIPOTECARIO PARA VIVIENDA	67	0.3%
2DO. PISO, M.N. REFACCIONARIO MAQ. Y EQ.	49	0.2%
Other values (16)	201	0.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
m.n	17499	14.6%
2do	16294	13.6%
piso	16294	13.6%
habilitacion	15834	13.2%
o	15834	13.2%
avio	15834	13.2%
simple	5666	4.7%
credito	3446	2.9%
fide	3446	2.9%
sin	1801	1.5%
Other values (34)	7778	6.5%

Most occurring characters

Value	Count	Frequency (%)
I	97186	13.7%
	96938	13.6%
O	86606	12.2%
A	58027	8.2%
.	52301	7.3%
N	40532	5.7%
S	26651	3.7%
D	26068	3.7%
L	25655	3.6%
M	24355	3.4%
Other values (17)	177396	24.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	711715	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
I	97186	13.7%
	96938	13.6%
O	86606	12.2%
A	58027	8.2%
.	52301	7.3%
N	40532	5.7%
S	26651	3.7%
D	26068	3.7%
L	25655	3.6%
M	24355	3.4%
Other values (17)	177396	24.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	711715	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
I	97186	13.7%
	96938	13.6%
O	86606	12.2%
A	58027	8.2%
.	52301	7.3%
N	40532	5.7%
S	26651	3.7%
D	26068	3.7%
L	25655	3.6%
M	24355	3.4%
Other values (17)	177396	24.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	711715	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
I	97186	13.7%
	96938	13.6%
O	86606	12.2%
A	58027	8.2%
.	52301	7.3%
N	40532	5.7%
S	26651	3.7%
D	26068	3.7%
L	25655	3.6%
M	24355	3.4%
Other values (17)	177396	24.9%

DESC_LINEA_FINANCIERA
Categorical

High correlation

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	178.2 KiB

2DO. PISO, BANCARIO	10125
2DO PISO NO BANC C/AVAL BANC	5324
DIRECTO CON DOCUMENTO	5263
2DO. PISO, SIN AVAL BANCARIO	845
DIRECTO SIN DOCUMENTO (INFONAVIT)	773
Other values (7)	458

Length

Max length	39
Median length	33
Mean length	22.507416
Min length	17

Characters and Unicode

Total characters	512899
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2DO PISO NO BANC C/AVAL BANC
2nd row	2DO. PISO, SIN AVAL BANCARIO
3rd row	2DO. PISO, SIN AVAL BANCARIO
4th row	2DO. PISO, SIN AVAL BANCARIO
5th row	2DO. PISO, BANCARIO

Common Values

Value	Count	Frequency (%)
2DO. PISO, BANCARIO	10125	44.4%
2DO PISO NO BANC C/AVAL BANC	5324	23.4%
DIRECTO CON DOCUMENTO	5263	23.1%
2DO. PISO, SIN AVAL BANCARIO	845	3.7%
DIRECTO SIN DOCUMENTO (INFONAVIT)	773	3.4%
DIRECTO SIN DOCUMENTO	212	0.9%
CREDITOS PARA LA VIVIENDA CON DOCUMENTO	74	0.3%
CREDITOS AL CONSUMO CON DOCUMENTO	68	0.3%
INTERBANCARIO EN EL PAIS	52	0.2%
AGENCIAS OTROS BA	48	0.2%
Other values (2)	4	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2do	16294	18.7%
piso	16294	18.7%
bancario	10970	12.6%
banc	10648	12.2%
documento	6392	7.3%
directo	6250	7.2%
con	5407	6.2%
no	5324	6.1%
c/aval	5324	6.1%
sin	1832	2.1%
Other values (19)	2478	2.8%

Most occurring characters

Value	Count	Frequency (%)
O	74526	14.5%
	64425	12.6%
A	46371	9.0%
C	45301	8.8%
N	42469	8.3%
I	37392	7.3%
D	29154	5.7%
B	21720	4.2%
S	18486	3.6%
R	17594	3.4%
Other values (15)	115461	22.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	512899	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
O	74526	14.5%
	64425	12.6%
A	46371	9.0%
C	45301	8.8%
N	42469	8.3%
I	37392	7.3%
D	29154	5.7%
B	21720	4.2%
S	18486	3.6%
R	17594	3.4%
Other values (15)	115461	22.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	512899	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
O	74526	14.5%
	64425	12.6%
A	46371	9.0%
C	45301	8.8%
N	42469	8.3%
I	37392	7.3%
D	29154	5.7%
B	21720	4.2%
S	18486	3.6%
R	17594	3.4%
Other values (15)	115461	22.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	512899	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
O	74526	14.5%
	64425	12.6%
A	46371	9.0%
C	45301	8.8%
N	42469	8.3%
I	37392	7.3%
D	29154	5.7%
B	21720	4.2%
S	18486	3.6%
R	17594	3.4%
Other values (15)	115461	22.5%

CODIGO_MONEDA
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	178.2 KiB

1	21907
54	881

Length

Max length	2
Median length	1
Mean length	1.0386607
Min length	1

Characters and Unicode

Total characters	23669
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	21907	96.1%
54	881	3.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	21907	96.1%
54	881	3.9%

Most occurring characters

Value	Count	Frequency (%)
1	21907	92.6%
5	881	3.7%
4	881	3.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	23669	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	21907	92.6%
5	881	3.7%
4	881	3.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	23669	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	21907	92.6%
5	881	3.7%
4	881	3.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	23669	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	21907	92.6%
5	881	3.7%
4	881	3.7%

MONTO_APROBADO
Real number (ℝ)

High correlation Skewed

Distinct	19382
Distinct (%)	85.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12640755

Minimum	19.54
Maximum	3.1544363 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	19.54
5-th percentile	780.6435
Q1	6404.265
median	44908.895
Q3	217785.95
95-th percentile	8000000
Maximum	3.1544363 × 10¹⁰
Range	3.1544363 × 10¹⁰
Interquartile range (IQR)	211381.69

Descriptive statistics

Standard deviation	2.7364312 × 10⁸
Coefficient of variation (CV)	21.647688
Kurtosis	7960.4082
Mean	12640755
Median Absolute Deviation (MAD)	43192.105
Skewness	76.079521
Sum	2.8805752 × 10¹¹
Variance	7.4880555 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25401.6	68	0.3%
10000000	51	0.2%
38054.24	42	0.2%
13680.12	39	0.2%
117192	38	0.2%
1963.42	35	0.2%
500000000	35	0.2%
59508	32	0.1%
3516.87	31	0.1%
2660.94	31	0.1%
Other values (19372)	22386	98.2%

Value	Count	Frequency (%)
19.54	1	< 0.1%
26.37	1	< 0.1%
38.42	1	< 0.1%
55	2	< 0.1%
56.94	1	< 0.1%
57.19	1	< 0.1%
58.81	1	< 0.1%
58.96	2	< 0.1%
59.05	1	< 0.1%
64.13	1	< 0.1%

Value	Count	Frequency (%)
3.154436258 × 10¹⁰	1	< 0.1%
8000000000	5	< 0.1%
6659653942	1	< 0.1%
6300000000	1	< 0.1%
5519565633	2	< 0.1%
5000000000	3	< 0.1%
4579393557	1	< 0.1%
3539135141	1	< 0.1%
3500000000	1	< 0.1%
2900000000	1	< 0.1%

MONTO_DISPONIBLE
Real number (ℝ)

High correlation Skewed Zeros

Distinct	1006
Distinct (%)	4.4%
Missing	17
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2407154.8

Minimum	0
Maximum	7.5 × 10⁹
Zeros	21570
Zeros (%)	94.7%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	38505.38
Maximum	7.5 × 10⁹
Range	7.5 × 10⁹
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.1181821 × 10⁸
Coefficient of variation (CV)	46.452438
Kurtosis	4437.104
Mean	2407154.8
Median Absolute Deviation (MAD)	0
Skewness	66.256229
Sum	5.4813322 × 10¹⁰
Variance	1.2503312 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	21570	94.7%
59508	16	0.1%
190000000	11	< 0.1%
15000000	7	< 0.1%
5833333.33	7	< 0.1%
10000000	6	< 0.1%
8333.34	6	< 0.1%
2009860.72	5	< 0.1%
3000000	5	< 0.1%
4198068.96	5	< 0.1%
Other values (996)	1133	5.0%
(Missing)	17	0.1%

Value	Count	Frequency (%)
0	21570	94.7%
0.02	1	< 0.1%
600	1	< 0.1%
834	1	< 0.1%
1000	3	< 0.1%
2000	2	< 0.1%
3000	1	< 0.1%
4000	1	< 0.1%
5166.66	2	< 0.1%
5166.67	2	< 0.1%

Value	Count	Frequency (%)
7500000000	5	< 0.1%
1000000000	1	< 0.1%
537839914.5	1	< 0.1%
480004949.1	1	< 0.1%
400000000	2	< 0.1%
388888888.9	1	< 0.1%
305555555.6	1	< 0.1%
292455269.8	1	< 0.1%
258932411.4	1	< 0.1%
250000000	1	< 0.1%

MONTO_INICIAL
Real number (ℝ)

High correlation Skewed

Distinct	19297
Distinct (%)	85.4%
Missing	204
Missing (%)	0.9%
Infinite	0
Infinite (%)	0.0%
Mean	10244431

Minimum	19.54
Maximum	3.1544363 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	19.54
5-th percentile	771.837
Q1	6295.4875
median	43395.94
Q3	209691.21
95-th percentile	6600000
Maximum	3.1544363 × 10¹⁰
Range	3.1544363 × 10¹⁰
Interquartile range (IQR)	203395.72

Descriptive statistics

Standard deviation	2.466864 × 10⁸
Coefficient of variation (CV)	24.08005
Kurtosis	11923.652
Mean	10244431
Median Absolute Deviation (MAD)	41742.85
Skewness	97.260629
Sum	2.3136023 × 10¹¹
Variance	6.0854181 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25401.6	68	0.3%
10000000	48	0.2%
38054.24	42	0.2%
13680.12	39	0.2%
117192	38	0.2%
1963.42	35	0.2%
500000000	34	0.1%
2661.12	31	0.1%
2660.94	31	0.1%
3516.87	31	0.1%
Other values (19287)	22187	97.4%
(Missing)	204	0.9%

Value	Count	Frequency (%)
19.54	1	< 0.1%
26.37	1	< 0.1%
38.42	1	< 0.1%
55	2	< 0.1%
56.94	1	< 0.1%
57.19	1	< 0.1%
58.81	1	< 0.1%
58.96	2	< 0.1%
59.05	1	< 0.1%
64.13	1	< 0.1%

Value	Count	Frequency (%)
3.154436258 × 10¹⁰	1	< 0.1%
6659653942	1	< 0.1%
6300000000	1	< 0.1%
5519565633	2	< 0.1%
5000000000	3	< 0.1%
4579393557	1	< 0.1%
3539135141	1	< 0.1%
3500000000	1	< 0.1%
2900000000	1	< 0.1%
2500000000	5	< 0.1%

TIPO_TASA
Categorical

High correlation Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	204
Missing (%)	0.9%
Memory size	178.2 KiB

6.0	15976
0.0	4584
5.0	1909
4.0	114
1.0	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	67752
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	5.0
2nd row	6.0
3rd row	6.0
4th row	6.0
5th row	6.0

Common Values

Value	Count	Frequency (%)
6.0	15976	70.1%
0.0	4584	20.1%
5.0	1909	8.4%
4.0	114	0.5%
1.0	1	< 0.1%
(Missing)	204	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
6.0	15976	70.7%
0.0	4584	20.3%
5.0	1909	8.5%
4.0	114	0.5%
1.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	27168	40.1%
.	22584	33.3%
6	15976	23.6%
5	1909	2.8%
4	114	0.2%
1	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	67752	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	27168	40.1%
.	22584	33.3%
6	15976	23.6%
5	1909	2.8%
4	114	0.2%
1	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	67752	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	27168	40.1%
.	22584	33.3%
6	15976	23.6%
5	1909	2.8%
4	114	0.2%
1	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	67752	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	27168	40.1%
.	22584	33.3%
6	15976	23.6%
5	1909	2.8%
4	114	0.2%
1	1	< 0.1%

TASA_TOTAL
Real number (ℝ)

High correlation

Distinct	1163
Distinct (%)	5.1%
Missing	204
Missing (%)	0.9%
Infinite	0
Infinite (%)	0.0%
Mean	11.652592

Minimum	0
Maximum	16.95
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	0
5-th percentile	7.47
Q1	11.7276
median	11.8132
Q3	12.06445
95-th percentile	13.444
Maximum	16.95
Range	16.95
Interquartile range (IQR)	0.33685

Descriptive statistics

Standard deviation	1.5729288
Coefficient of variation (CV)	0.13498532
Kurtosis	6.8109543
Mean	11.652592
Median Absolute Deviation (MAD)	0.2068
Skewness	-2.2648545
Sum	263162.13
Variance	2.4741051
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11.7753	690	3.0%
7.47	616	2.7%
11.7841	470	2.1%
11.7549	391	1.7%
11.9105	357	1.6%
10.23	356	1.6%
11.8083	345	1.5%
11.8032	333	1.5%
11.8404	312	1.4%
12.0664	300	1.3%
Other values (1153)	18414	80.8%

Value	Count	Frequency (%)
0	4	< 0.1%
1.48	2	< 0.1%
1.57	2	< 0.1%
1.63	1	< 0.1%
3.7	1	< 0.1%
3.75	11	< 0.1%
4	5	< 0.1%
4.3623	1	< 0.1%
4.42	17	0.1%
4.422	17	0.1%

Value	Count	Frequency (%)
16.95	13	0.1%
15.7205	2	< 0.1%
15.63	4	< 0.1%
15.6299	5	< 0.1%
15.62	5	< 0.1%
15.6057	4	< 0.1%
15.4337	2	< 0.1%
15.4335	8	< 0.1%
15.43	12	0.1%
15.4299	1	< 0.1%

PLAZO
Real number (ℝ)

High correlation

Distinct	1214
Distinct (%)	5.4%
Missing	204
Missing (%)	0.9%
Infinite	0
Infinite (%)	0.0%
Mean	652.90166

Minimum	30
Maximum	12450
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	30
5-th percentile	107
Q1	120
median	168
Q3	455
95-th percentile	1822
Maximum	12450
Range	12420
Interquartile range (IQR)	335

Descriptive statistics

Standard deviation	1170.7373
Coefficient of variation (CV)	1.7931296
Kurtosis	17.267487
Mean	652.90166
Median Absolute Deviation (MAD)	48
Skewness	3.7105776
Sum	14745131
Variance	1370625.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
177	995	4.4%
178	865	3.8%
119	797	3.5%
112	650	2.9%
174	640	2.8%
179	632	2.8%
120	621	2.7%
176	576	2.5%
114	528	2.3%
123	500	2.2%
Other values (1204)	15780	69.2%

Value	Count	Frequency (%)
30	4	< 0.1%
49	5	< 0.1%
57	1	< 0.1%
77	1	< 0.1%
79	1	< 0.1%
84	6	< 0.1%
87	1	< 0.1%
90	1	< 0.1%
91	1	< 0.1%
94	28	0.1%

Value	Count	Frequency (%)
12450	1	< 0.1%
12262	2	< 0.1%
9999	1	< 0.1%
9987	1	< 0.1%
9102	1	< 0.1%
9101	1	< 0.1%
7951	2	< 0.1%
7950	2	< 0.1%
7922	4	< 0.1%
7897	4	< 0.1%

CODIGO_TIPO_AMORTIZACION
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	204
Missing (%)	0.9%
Memory size	178.2 KiB

1.0	16572
5.0	4745
3.0	992
2.0	275

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	67752
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	16572	72.7%
5.0	4745	20.8%
3.0	992	4.4%
2.0	275	1.2%
(Missing)	204	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	16572	73.4%
5.0	4745	21.0%
3.0	992	4.4%
2.0	275	1.2%

Most occurring characters

Value	Count	Frequency (%)
.	22584	33.3%
0	22584	33.3%
1	16572	24.5%
5	4745	7.0%
3	992	1.5%
2	275	0.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	67752	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
.	22584	33.3%
0	22584	33.3%
1	16572	24.5%
5	4745	7.0%
3	992	1.5%
2	275	0.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	67752	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
.	22584	33.3%
0	22584	33.3%
1	16572	24.5%
5	4745	7.0%
3	992	1.5%
2	275	0.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	67752	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
.	22584	33.3%
0	22584	33.3%
1	16572	24.5%
5	4745	7.0%
3	992	1.5%
2	275	0.4%

AMORTIZACION
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	204
Missing (%)	0.9%
Memory size	178.2 KiB

CAPITAL E INTERES AL VCTO	16572
PLAN DE PAGOS	4745
PAGOS IGUALES CAP. MAS INTS.	992
INT. MENSUAL Y CAP. AL VENC.	275

Length

Max length	28
Median length	25
Mean length	22.647051
Min length	13

Characters and Unicode

Total characters	511461
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PLAN DE PAGOS
2nd row	CAPITAL E INTERES AL VCTO
3rd row	CAPITAL E INTERES AL VCTO
4th row	CAPITAL E INTERES AL VCTO
5th row	CAPITAL E INTERES AL VCTO

Common Values

Value	Count	Frequency (%)
CAPITAL E INTERES AL VCTO	16572	72.7%
PLAN DE PAGOS	4745	20.8%
PAGOS IGUALES CAP. MAS INTS.	992	4.4%
INT. MENSUAL Y CAP. AL VENC.	275	1.2%
(Missing)	204	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
al	16847	16.2%
capital	16572	16.0%
e	16572	16.0%
interes	16572	16.0%
vcto	16572	16.0%
pagos	5737	5.5%
plan	4745	4.6%
de	4745	4.6%
cap	1267	1.2%
iguales	992	1.0%
Other values (6)	3084	3.0%

Most occurring characters

Value	Count	Frequency (%)
	81121	15.9%
A	63999	12.5%
E	56003	10.9%
T	50983	10.0%
L	39431	7.7%
I	35403	6.9%
C	34686	6.8%
P	28321	5.5%
S	25560	5.0%
N	23134	4.5%
Other values (9)	72820	14.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	511461	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	81121	15.9%
A	63999	12.5%
E	56003	10.9%
T	50983	10.0%
L	39431	7.7%
I	35403	6.9%
C	34686	6.8%
P	28321	5.5%
S	25560	5.0%
N	23134	4.5%
Other values (9)	72820	14.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	511461	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	81121	15.9%
A	63999	12.5%
E	56003	10.9%
T	50983	10.0%
L	39431	7.7%
I	35403	6.9%
C	34686	6.8%
P	28321	5.5%
S	25560	5.0%
N	23134	4.5%
Other values (9)	72820	14.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	511461	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	81121	15.9%
A	63999	12.5%
E	56003	10.9%
T	50983	10.0%
L	39431	7.7%
I	35403	6.9%
C	34686	6.8%
P	28321	5.5%
S	25560	5.0%
N	23134	4.5%
Other values (9)	72820	14.2%

NUMERO_CUOTAS
Real number (ℝ)

High correlation

Distinct	178
Distinct (%)	0.8%
Missing	204
Missing (%)	0.9%
Infinite	0
Infinite (%)	0.0%
Mean	12.203507

Minimum	1
Maximum	329
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	12
95-th percentile	60
Maximum	329
Range	328
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	24.79449
Coefficient of variation (CV)	2.0317512
Kurtosis	25.863856
Mean	12.203507
Median Absolute Deviation (MAD)	0
Skewness	4.0389249
Sum	275604
Variance	614.76671
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	16577	72.7%
30	2696	11.8%
60	827	3.6%
24	188	0.8%
36	161	0.7%
48	156	0.7%
6	133	0.6%
84	61	0.3%
12	53	0.2%
46	52	0.2%
Other values (168)	1680	7.4%
(Missing)	204	0.9%

Value	Count	Frequency (%)
1	16577	72.7%
2	1	< 0.1%
3	7	< 0.1%
4	21	0.1%
5	33	0.1%
6	133	0.6%
7	32	0.1%
8	14	0.1%
9	12	0.1%
10	32	0.1%

Value	Count	Frequency (%)
329	2	< 0.1%
300	2	< 0.1%
244	4	< 0.1%
240	1	< 0.1%
237	1	< 0.1%
236	1	< 0.1%
234	3	< 0.1%
233	4	< 0.1%
232	4	< 0.1%
231	3	< 0.1%

VALOR_CUOTA
Real number (ℝ)

High correlation Missing Skewed Zeros

Distinct	20123
Distinct (%)	89.2%
Missing	234
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%
Mean	333404.99

Minimum	0
Maximum	1.6666667 × 10⁹
Zeros	299
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	0
5-th percentile	577.758
Q1	3417.775
median	13277.66
Q3	67141.32
95-th percentile	707683.65
Maximum	1.6666667 × 10⁹
Range	1.6666667 × 10⁹
Interquartile range (IQR)	63723.545

Descriptive statistics

Standard deviation	11383127
Coefficient of variation (CV)	34.14204
Kurtosis	20370.172
Mean	333404.99
Median Absolute Deviation (MAD)	11897.93
Skewness	139.58947
Sum	7.5196162 × 10⁹
Variance	1.2957557 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	299	1.3%
1000	48	0.2%
14191.98	39	0.2%
2047.21	35	0.2%
2760.12	31	0.1%
2760.3	31	0.1%
3671.45	31	0.1%
2760.69	28	0.1%
1874.71	25	0.1%
4240.51	23	0.1%
Other values (20113)	21964	96.4%
(Missing)	234	1.0%

Value	Count	Frequency (%)
0	299	1.3%
1	1	< 0.1%
20.87	1	< 0.1%
27.53	1	< 0.1%
30.83	1	< 0.1%
39.61	1	< 0.1%
44.84	1	< 0.1%
58.52	2	< 0.1%
59.42	1	< 0.1%
60.71	1	< 0.1%

Value	Count	Frequency (%)
1666666667	1	< 0.1%
186244751.5	1	< 0.1%
186244751.5	1	< 0.1%
94500000	1	< 0.1%
73256193.36	1	< 0.1%
72916666.67	1	< 0.1%
67567567.57	1	< 0.1%
59333286.96	1	< 0.1%
52083333.33	1	< 0.1%
41921318.19	1	< 0.1%

CANTIDAD_CUOTAS_PAGADAS
Real number (ℝ)

High correlation Missing Zeros

Distinct	117
Distinct (%)	0.5%
Missing	257
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%
Mean	4.623674

Minimum	0
Maximum	211
Zeros	16848
Zeros (%)	73.9%
Negative	0
Negative (%)	0.0%
Memory size	178.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	25
Maximum	211
Range	211
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	12.080761
Coefficient of variation (CV)	2.6128055
Kurtosis	65.303448
Mean	4.623674
Median Absolute Deviation (MAD)	0
Skewness	6.1029592
Sum	104176
Variance	145.94479
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	16848	73.9%
1	289	1.3%
2	228	1.0%
22	220	1.0%
16	219	1.0%
12	216	0.9%
3	215	0.9%
20	209	0.9%
15	203	0.9%
14	200	0.9%
Other values (107)	3684	16.2%
(Missing)	257	1.1%

Value	Count	Frequency (%)
0	16848	73.9%
1	289	1.3%
2	228	1.0%
3	215	0.9%
4	191	0.8%
5	144	0.6%
6	144	0.6%
7	122	0.5%
8	148	0.6%
9	184	0.8%

Value	Count	Frequency (%)
211	1	< 0.1%
208	1	< 0.1%
191	1	< 0.1%
190	3	< 0.1%
188	1	< 0.1%
183	4	< 0.1%
181	1	< 0.1%
175	1	< 0.1%
174	4	< 0.1%
168	1	< 0.1%

Interactions

Correlations

	AMORTIZACION	AÑO_REGISTRO	AÑO_VENCIMIENTO	CANTIDAD_CUOTAS_PAGADAS	CODIGO_CLIENTE	CODIGO_MONEDA	CODIGO_TIPO_AMORTIZACION	CODIGO_TIPO_IDENTIFICACION	DELEGACION_MUNICIPIO	DESC_LINEA_FINANCIERA	DIA_REGISTRO	DIA_VENCIMIENTO	ENTIDAD_FEDERATIVA	MES_REGISTRO	MES_VENCIMIENTO	MONTO_APROBADO	MONTO_DISPONIBLE	MONTO_INICIAL	NACIONALIDAD	NO_EMPLEADOS	NUMERO_CONTRATO	NUMERO_CUOTAS	NUMERO_PRESTAMO	PAIS	PLAZO	PRODUCTO	SEXO	TASA_TOTAL	TIPO_SECTOR	TIPO_SUBSECTOR	TIPO_TASA	VALOR_CUOTA	VENTAS_NETAS
AMORTIZACION	1.000	0.498	0.046	0.305	0.286	0.164	1.000	0.350	0.690	0.586	0.093	0.404	0.619	0.410	0.439	0.056	0.037	0.058	0.019	0.081	0.406	0.374	0.407	0.019	0.538	0.720	0.075	0.341	0.429	0.636	0.620	0.011	0.055
AÑO_REGISTRO	0.498	1.000	-0.712	-0.893	-0.254	0.545	0.498	0.333	0.751	0.408	-0.026	-0.257	0.684	0.296	-0.483	-0.482	-0.205	-0.471	0.000	0.391	0.700	-0.829	0.692	0.000	-0.656	0.456	0.071	0.158	0.290	0.376	0.480	0.122	0.284
AÑO_VENCIMIENTO	0.046	-0.712	1.000	0.834	0.319	0.000	0.046	0.005	1.000	0.145	0.024	0.263	1.000	-0.398	0.463	0.535	0.227	0.532	0.000	-0.385	-0.614	0.900	-0.617	0.000	0.704	0.358	0.000	0.038	0.000	0.097	0.074	-0.125	-0.282
CANTIDAD_CUOTAS_PAGADAS	0.305	-0.893	0.834	1.000	0.267	0.276	0.305	0.086	0.627	0.313	0.033	0.272	0.495	-0.413	0.522	0.580	0.344	0.580	0.000	-0.396	-0.739	0.959	-0.739	0.000	0.737	0.343	0.000	-0.047	0.126	0.254	0.382	-0.107	-0.286
CODIGO_CLIENTE	0.286	-0.254	0.319	0.267	1.000	0.281	0.286	0.371	0.947	0.223	0.020	0.195	0.803	0.018	0.043	0.093	-0.081	0.097	0.000	-0.503	-0.068	0.278	-0.072	0.000	0.047	0.255	0.205	-0.082	0.181	0.355	0.194	-0.134	-0.396
CODIGO_MONEDA	0.164	0.545	0.000	0.276	0.281	1.000	0.164	0.132	1.000	0.457	0.065	0.218	1.000	0.121	0.261	0.000	0.000	0.000	0.000	0.206	0.518	0.489	0.535	0.000	0.585	0.999	0.000	0.803	0.258	0.304	0.231	0.000	0.067
CODIGO_TIPO_AMORTIZACION	1.000	0.498	0.046	0.305	0.286	0.164	1.000	0.350	0.690	0.586	0.093	0.404	0.619	0.410	0.439	0.056	0.037	0.058	0.019	0.081	0.406	0.374	0.407	0.019	0.538	0.720	0.075	0.341	0.429	0.636	0.620	0.011	0.055
CODIGO_TIPO_IDENTIFICACION	0.350	0.333	0.005	0.086	0.371	0.132	0.350	1.000	0.970	0.352	0.108	0.338	0.893	0.221	0.194	0.013	0.005	0.009	0.015	0.032	0.322	0.106	0.335	0.015	0.386	0.540	1.000	0.160	0.277	0.589	0.399	0.000	0.012
DELEGACION_MUNICIPIO	0.690	0.751	1.000	0.627	0.947	1.000	0.690	0.970	1.000	0.864	0.238	0.522	0.988	0.605	0.548	1.000	1.000	1.000	1.000	1.000	0.771	0.778	0.771	1.000	0.809	0.816	0.975	0.852	0.872	0.921	0.905	1.000	1.000
DESC_LINEA_FINANCIERA	0.586	0.408	0.145	0.313	0.223	0.457	0.586	0.352	0.864	1.000	0.090	0.261	0.759	0.253	0.281	0.110	0.000	0.133	0.084	0.336	0.375	0.413	0.378	0.084	0.421	0.760	0.186	0.290	0.314	0.482	0.685	0.069	0.471
DIA_REGISTRO	0.093	-0.026	0.024	0.033	0.020	0.065	0.093	0.108	0.238	0.090	1.000	0.187	0.210	-0.255	-0.068	0.065	0.023	0.067	0.021	0.054	-0.090	0.032	-0.095	0.021	0.046	0.083	0.114	0.013	0.085	0.147	0.097	0.059	0.073
DIA_VENCIMIENTO	0.404	-0.257	0.263	0.272	0.195	0.218	0.404	0.338	0.522	0.261	0.187	1.000	0.463	-0.192	-0.092	0.195	0.008	0.198	0.000	-0.067	-0.235	0.274	-0.242	0.000	0.240	0.288	0.114	0.164	0.192	0.289	0.343	-0.027	-0.094
ENTIDAD_FEDERATIVA	0.619	0.684	1.000	0.495	0.803	1.000	0.619	0.893	0.988	0.759	0.210	0.463	1.000	0.478	0.472	1.000	1.000	1.000	1.000	1.000	0.745	0.678	0.745	1.000	0.727	0.706	0.786	0.823	0.752	0.698	0.858	1.000	1.000
MES_REGISTRO	0.410	0.296	-0.398	-0.413	0.018	0.121	0.410	0.221	0.605	0.253	-0.255	-0.192	0.478	1.000	-0.050	-0.282	-0.157	-0.279	0.024	-0.040	0.723	-0.402	0.726	0.024	-0.622	0.257	0.052	-0.230	0.198	0.285	0.314	0.020	0.043
MES_VENCIMIENTO	0.439	-0.483	0.463	0.522	0.043	0.261	0.439	0.194	0.548	0.281	-0.068	-0.092	0.472	-0.050	1.000	0.379	0.232	0.372	0.026	-0.221	-0.344	0.548	-0.343	0.026	0.603	0.298	0.066	-0.087	0.179	0.251	0.353	-0.022	-0.145
MONTO_APROBADO	0.056	-0.482	0.535	0.580	0.093	0.000	0.056	0.013	1.000	0.110	0.065	0.195	1.000	-0.282	0.379	1.000	0.342	0.999	0.000	-0.086	-0.444	0.619	-0.437	0.000	0.495	0.369	1.000	0.095	0.071	0.140	0.049	0.660	0.011
MONTO_DISPONIBLE	0.037	-0.205	0.227	0.344	-0.081	0.000	0.037	0.005	1.000	0.000	0.023	0.008	1.000	-0.157	0.232	0.342	1.000	0.320	0.000	0.110	-0.218	0.357	-0.207	0.000	0.228	0.026	1.000	0.264	0.034	0.085	0.047	0.183	0.177
MONTO_INICIAL	0.058	-0.471	0.532	0.580	0.097	0.000	0.058	0.009	1.000	0.133	0.067	0.198	1.000	-0.279	0.372	0.999	0.320	1.000	0.000	-0.095	-0.437	0.618	-0.437	0.000	0.495	0.380	1.000	0.095	0.067	0.137	0.040	0.661	0.000
NACIONALIDAD	0.019	0.000	0.000	0.000	0.000	0.000	0.019	0.015	1.000	0.084	0.021	0.000	1.000	0.024	0.026	0.000	0.000	0.000	1.000	0.000	0.000	0.030	0.000	1.000	0.054	0.111	0.003	0.013	0.014	0.185	0.065	0.000	0.000
NO_EMPLEADOS	0.081	0.391	-0.385	-0.396	-0.503	0.206	0.081	0.032	1.000	0.336	0.054	-0.067	1.000	-0.040	-0.221	-0.086	0.110	-0.095	0.000	1.000	0.112	-0.381	0.120	0.000	-0.134	0.348	1.000	0.169	0.196	0.311	0.073	0.247	0.674
NUMERO_CONTRATO	0.406	0.700	-0.614	-0.739	-0.068	0.518	0.406	0.322	0.771	0.375	-0.090	-0.235	0.745	0.723	-0.344	-0.444	-0.218	-0.437	0.000	0.112	1.000	-0.696	1.000	0.000	-0.855	0.421	0.048	-0.132	0.276	0.352	0.434	0.066	0.140
NUMERO_CUOTAS	0.374	-0.829	0.900	0.959	0.278	0.489	0.374	0.106	0.778	0.413	0.032	0.274	0.678	-0.402	0.548	0.619	0.357	0.618	0.030	-0.381	-0.696	1.000	-0.696	0.030	0.758	0.536	0.000	-0.010	0.202	0.328	0.430	-0.091	-0.269
NUMERO_PRESTAMO	0.407	0.692	-0.617	-0.739	-0.072	0.535	0.407	0.335	0.771	0.378	-0.095	-0.242	0.745	0.726	-0.343	-0.437	-0.207	-0.437	0.000	0.120	1.000	-0.696	1.000	0.000	-0.855	0.428	0.047	-0.132	0.270	0.353	0.434	0.066	0.152
PAIS	0.019	0.000	0.000	0.000	0.000	0.000	0.019	0.015	1.000	0.084	0.021	0.000	1.000	0.024	0.026	0.000	0.000	0.000	1.000	0.000	0.000	0.030	0.000	1.000	0.054	0.111	0.003	0.013	0.014	0.185	0.065	0.000	0.000
PLAZO	0.538	-0.656	0.704	0.737	0.047	0.585	0.538	0.386	0.809	0.421	0.046	0.240	0.727	-0.622	0.603	0.495	0.228	0.495	0.054	-0.134	-0.855	0.758	-0.855	0.054	1.000	0.561	0.074	0.103	0.265	0.399	0.472	-0.057	-0.155
PRODUCTO	0.720	0.456	0.358	0.343	0.255	0.999	0.720	0.540	0.816	0.760	0.083	0.288	0.706	0.257	0.298	0.369	0.026	0.380	0.111	0.348	0.421	0.536	0.428	0.111	0.561	1.000	0.080	0.451	0.448	0.371	0.808	0.439	0.425
SEXO	0.075	0.071	0.000	0.000	0.205	0.000	0.075	1.000	0.975	0.186	0.114	0.114	0.786	0.052	0.066	1.000	1.000	1.000	0.003	1.000	0.048	0.000	0.047	0.003	0.074	0.080	1.000	0.026	0.230	0.308	0.080	1.000	1.000
TASA_TOTAL	0.341	0.158	0.038	-0.047	-0.082	0.803	0.341	0.160	0.852	0.290	0.013	0.164	0.823	-0.230	-0.087	0.095	0.264	0.095	0.013	0.169	-0.132	-0.010	-0.132	0.013	0.103	0.451	0.026	1.000	0.223	0.313	0.316	0.097	0.083
TIPO_SECTOR	0.429	0.290	0.000	0.126	0.181	0.258	0.429	0.277	0.872	0.314	0.085	0.192	0.752	0.198	0.179	0.071	0.034	0.067	0.014	0.196	0.276	0.202	0.270	0.014	0.265	0.448	0.230	0.223	1.000	1.000	0.477	0.119	0.242
TIPO_SUBSECTOR	0.636	0.376	0.097	0.254	0.355	0.304	0.636	0.589	0.921	0.482	0.147	0.289	0.698	0.285	0.251	0.140	0.085	0.137	0.185	0.311	0.352	0.328	0.353	0.185	0.399	0.371	0.308	0.313	1.000	1.000	0.720	0.115	0.385
TIPO_TASA	0.620	0.480	0.074	0.382	0.194	0.231	0.620	0.399	0.905	0.685	0.097	0.343	0.858	0.314	0.353	0.049	0.047	0.040	0.065	0.073	0.434	0.430	0.434	0.065	0.472	0.808	0.080	0.316	0.477	0.720	1.000	0.023	0.036
VALOR_CUOTA	0.011	0.122	-0.125	-0.107	-0.134	0.000	0.011	0.000	1.000	0.069	0.059	-0.027	1.000	0.020	-0.022	0.660	0.183	0.661	0.000	0.247	0.066	-0.091	0.066	0.000	-0.057	0.439	1.000	0.097	0.119	0.115	0.023	1.000	0.272
VENTAS_NETAS	0.055	0.284	-0.282	-0.286	-0.396	0.067	0.055	0.012	1.000	0.471	0.073	-0.094	1.000	0.043	-0.145	0.011	0.177	0.000	0.000	0.674	0.140	-0.269	0.152	0.000	-0.155	0.425	1.000	0.083	0.242	0.385	0.036	0.272	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	CODIGO_CLIENTE	CODIGO_TIPO_IDENTIFICACION	NOMBRES	PRIMER_APELLIDO	SEGUNDO_APELLIDO	SEXO	FECHA_DE_NACIMIENTO	RAZON_SOCIAL	NOMBRE_COMERCIAL	NO_EMPLEADOS	VENTAS_NETAS	PAIS	NACIONALIDAD	DELEGACION_MUNICIPIO	ENTIDAD_FEDERATIVA	TIPO_SECTOR	TIPO_SUBSECTOR	TIPO_RAMA	TIPO_CLASE	NUMERO_CONTRATO	NUMERO_PRESTAMO	FECHA_APERTURA	AÑO_REGISTRO	MES_REGISTRO	DIA_REGISTRO	FECHA_VENCIMIENTO	AÑO_VENCIMIENTO	MES_VENCIMIENTO	DIA_VENCIMIENTO	PRODUCTO	DESC_LINEA_FINANCIERA	CODIGO_MONEDA	MONTO_APROBADO	MONTO_INICIAL	TIPO_TASA	TASA_TOTAL	PLAZO	CODIGO_TIPO_AMORTIZACION	AMORTIZACION	NUMERO_CUOTAS	VALOR_CUOTA	CANTIDAD_CUOTAS_PAGADAS
0	63041	7	NaN	NaN	NaN	NaN	NaN	LAMINA DESPLEGADA SA DE CV	LAMINA DESPLEGADA SA DE CV	767	1.104424e+06	MEXICO	MEXICANA	SANTA CATARINA LA FAMA	NUEVO LEON	INDUSTRIAS MANUFACTURERAS	INDUSTRIAS METALICAS BASICAS	INDUSTRIAS BASICAS DE METALES NO FERROSOS. (I) EL TRATAMIENT	FUNDICION, LAMINACION, EXTRUSION, REFINACION Y/O ESTIRAJE DE	39154419	405327964.0	2023-11-14 00:00:00	2023	11	14	2025-04-16 00:00:00	2025	4	16	2DO. PISO, M.N. SIMPLE	2DO PISO NO BANC C/AVAL BANC	1	1381152.29	1381152.29	5.0	11.3234	519.0	5.0	PLAN DE PAGOS	17.0	84079.47	11.0
1	99003	7	NaN	NaN	NaN	NaN	NaN	CAFE EL MARINO	CAFE EL MARINO	249	4.900000e+07	MEXICO	MEXICANA	MAZATLAN	SINALOA	INDUSTRIAS MANUFACTURERAS	PRODUCTOS ALIMENTICIOS, BEBIDAS Y TABACO	BENEFICIO Y MOLIENDA DE CEREALES Y OTROS PRODUCTOS AGRICOLAS	BENEFICIO DE CAFE	40689525	420677745.0	2024-11-01 00:00:00	2024	11	1	2025-04-03 00:00:00	2025	4	3	2DO. PISO, M.N. HABILITACION O AVIO	2DO. PISO, SIN AVAL BANCARIO	1	15921.29	15921.29	6.0	12.7549	153.0	1.0	CAPITAL E INTERES AL VCTO	1.0	16784.21	0.0
2	99003	7	NaN	NaN	NaN	NaN	NaN	CAFE EL MARINO	CAFE EL MARINO	249	4.900000e+07	MEXICO	MEXICANA	MAZATLAN	SINALOA	INDUSTRIAS MANUFACTURERAS	PRODUCTOS ALIMENTICIOS, BEBIDAS Y TABACO	BENEFICIO Y MOLIENDA DE CEREALES Y OTROS PRODUCTOS AGRICOLAS	BENEFICIO DE CAFE	40585141	419633900.0	2024-10-08 00:00:00	2024	10	8	2025-03-03 00:00:00	2025	3	3	2DO. PISO, M.N. HABILITACION O AVIO	2DO. PISO, SIN AVAL BANCARIO	1	5886.97	5886.97	6.0	12.6743	146.0	1.0	CAPITAL E INTERES AL VCTO	1.0	6189.19	0.0
3	99003	7	NaN	NaN	NaN	NaN	NaN	CAFE EL MARINO	CAFE EL MARINO	249	4.900000e+07	MEXICO	MEXICANA	MAZATLAN	SINALOA	INDUSTRIAS MANUFACTURERAS	PRODUCTOS ALIMENTICIOS, BEBIDAS Y TABACO	BENEFICIO Y MOLIENDA DE CEREALES Y OTROS PRODUCTOS AGRICOLAS	BENEFICIO DE CAFE	40585144	419633937.0	2024-10-08 00:00:00	2024	10	8	2025-02-17 00:00:00	2025	2	17	2DO. PISO, M.N. HABILITACION O AVIO	2DO. PISO, SIN AVAL BANCARIO	1	5930.55	5930.55	6.0	12.6743	132.0	1.0	CAPITAL E INTERES AL VCTO	1.0	6206.43	0.0
4	123173	7	NaN	NaN	NaN	NaN	NaN	SCHETTINO HERMANOS, S. DE R.L. DE C.V.	SCHETTINO HERMANOS, S. DE R.L. DE C.V.	281	2.106982e+09	MEXICO	MEXICANA	ORIZABA	VERACRUZ	COMERCIO	COMERCIO AL POR MAYOR	COMERCIO DE PRODUCTOS ALIMENTICIOS, BEBIDAS Y TABACO AL POR	CHILE SECO Y ESPECIAS (I) PASTA PARA MOLE Y SIMILARES	40373372	417516219.0	2024-08-19 00:00:00	2024	8	19	2025-02-11 00:00:00	2025	2	11	2DO. PISO, M.N. HABILITACION O AVIO	2DO. PISO, BANCARIO	1	93107.00	93107.00	6.0	12.1024	176.0	1.0	CAPITAL E INTERES AL VCTO	1.0	98615.80	0.0
5	123173	7	NaN	NaN	NaN	NaN	NaN	SCHETTINO HERMANOS, S. DE R.L. DE C.V.	SCHETTINO HERMANOS, S. DE R.L. DE C.V.	281	2.106982e+09	MEXICO	MEXICANA	ORIZABA	VERACRUZ	COMERCIO	COMERCIO AL POR MAYOR	COMERCIO DE PRODUCTOS ALIMENTICIOS, BEBIDAS Y TABACO AL POR	CHILE SECO Y ESPECIAS (I) PASTA PARA MOLE Y SIMILARES	40618611	419968586.0	2024-10-16 00:00:00	2024	10	16	2025-04-07 00:00:00	2025	4	7	2DO. PISO, M.N. HABILITACION O AVIO	2DO. PISO, BANCARIO	1	258057.03	258057.03	6.0	11.6871	173.0	1.0	CAPITAL E INTERES AL VCTO	1.0	272550.97	0.0
6	128196	7	NaN	NaN	NaN	NaN	NaN	ALIMENTOS COMPEAN S.A. DE CV	ALIMENTOS COMPEAN S.A. DE CV	50	3.000000e+07	MEXICO	MEXICANA	SAN LUIS POTOSI	SAN LUIS POTOSI	INDUSTRIAS MANUFACTURERAS	PRODUCTOS ALIMENTICIOS, BEBIDAS Y TABACO	ELABORACION DE OTROS PRODUCTOS ALIMENTICIOS PARA EL CONSUMO	ELABORACION DE OTROS PRODUCTOS ALIMENTICIOS PARA CONSUMO HUM	40482018	418602669.0	2024-09-12 00:00:00	2024	9	12	2025-02-27 00:00:00	2025	2	27	2DO. PISO, M.N. HABILITACION O AVIO	2DO PISO NO BANC C/AVAL BANC	1	41021.74	41021.74	6.0	12.1526	168.0	1.0	CAPITAL E INTERES AL VCTO	1.0	43348.54	0.0
7	128196	7	NaN	NaN	NaN	NaN	NaN	ALIMENTOS COMPEAN S.A. DE CV	ALIMENTOS COMPEAN S.A. DE CV	50	3.000000e+07	MEXICO	MEXICANA	SAN LUIS POTOSI	SAN LUIS POTOSI	INDUSTRIAS MANUFACTURERAS	PRODUCTOS ALIMENTICIOS, BEBIDAS Y TABACO	ELABORACION DE OTROS PRODUCTOS ALIMENTICIOS PARA EL CONSUMO	ELABORACION DE OTROS PRODUCTOS ALIMENTICIOS PARA CONSUMO HUM	40482019	418602650.0	2024-09-12 00:00:00	2024	9	12	2025-02-27 00:00:00	2025	2	27	2DO. PISO, M.N. HABILITACION O AVIO	2DO PISO NO BANC C/AVAL BANC	1	80915.74	80915.74	6.0	12.1526	168.0	1.0	CAPITAL E INTERES AL VCTO	1.0	85503.82	0.0
8	128196	7	NaN	NaN	NaN	NaN	NaN	ALIMENTOS COMPEAN S.A. DE CV	ALIMENTOS COMPEAN S.A. DE CV	50	3.000000e+07	MEXICO	MEXICANA	SAN LUIS POTOSI	SAN LUIS POTOSI	INDUSTRIAS MANUFACTURERAS	PRODUCTOS ALIMENTICIOS, BEBIDAS Y TABACO	ELABORACION DE OTROS PRODUCTOS ALIMENTICIOS PARA EL CONSUMO	ELABORACION DE OTROS PRODUCTOS ALIMENTICIOS PARA CONSUMO HUM	40482015	418602641.0	2024-09-12 00:00:00	2024	9	12	2025-02-27 00:00:00	2025	2	27	2DO. PISO, M.N. HABILITACION O AVIO	2DO PISO NO BANC C/AVAL BANC	1	41021.74	41021.74	6.0	12.1526	168.0	1.0	CAPITAL E INTERES AL VCTO	1.0	43348.54	0.0
9	128196	7	NaN	NaN	NaN	NaN	NaN	ALIMENTOS COMPEAN S.A. DE CV	ALIMENTOS COMPEAN S.A. DE CV	50	3.000000e+07	MEXICO	MEXICANA	SAN LUIS POTOSI	SAN LUIS POTOSI	INDUSTRIAS MANUFACTURERAS	PRODUCTOS ALIMENTICIOS, BEBIDAS Y TABACO	ELABORACION DE OTROS PRODUCTOS ALIMENTICIOS PARA EL CONSUMO	ELABORACION DE OTROS PRODUCTOS ALIMENTICIOS PARA CONSUMO HUM	40482014	418602632.0	2024-09-12 00:00:00	2024	9	12	2025-02-27 00:00:00	2025	2	27	2DO. PISO, M.N. HABILITACION O AVIO	2DO PISO NO BANC C/AVAL BANC	1	23043.60	23043.60	6.0	12.1526	168.0	1.0	CAPITAL E INTERES AL VCTO	1.0	24350.64	0.0

	CODIGO_CLIENTE	CODIGO_TIPO_IDENTIFICACION	NOMBRES	PRIMER_APELLIDO	SEGUNDO_APELLIDO	SEXO	FECHA_DE_NACIMIENTO	RAZON_SOCIAL	NOMBRE_COMERCIAL	NO_EMPLEADOS	VENTAS_NETAS	PAIS	NACIONALIDAD	DELEGACION_MUNICIPIO	ENTIDAD_FEDERATIVA	TIPO_SECTOR	TIPO_SUBSECTOR	TIPO_RAMA	TIPO_CLASE	NUMERO_CONTRATO	NUMERO_PRESTAMO	FECHA_APERTURA	AÑO_REGISTRO	MES_REGISTRO	DIA_REGISTRO	FECHA_VENCIMIENTO	AÑO_VENCIMIENTO	MES_VENCIMIENTO	DIA_VENCIMIENTO	PRODUCTO	DESC_LINEA_FINANCIERA	CODIGO_MONEDA	MONTO_APROBADO	MONTO_DISPONIBLE	MONTO_INICIAL	TIPO_TASA	TASA_TOTAL	PLAZO	CODIGO_TIPO_AMORTIZACION	AMORTIZACION	NUMERO_CUOTAS	VALOR_CUOTA	CANTIDAD_CUOTAS_PAGADAS
22778	28950763	5	RAUL	ALEGRIA	RIOS	M	1978-11-12 00:00:00	NaN	NaN	1	5001.0	MEXICO	MEXICANA	NaN	NaN	INDUSTRIAS MANUFACTURERAS	PRODUCTOS METALICOS ,MAQUINARIA Y EQUIPO.(I) INSTRUMENTOS Q	FABRICACION, REPARACION Y/O ENSAMBLE DE MAQUINARIA Y EQUIPO	FABRICACION DE EQUIPOS Y APARATOS DE AIRE ACONDICIONADO, REF	40704517	420827672.0	2024-11-05 00:00:00	2024	11	5	2029-09-29 00:00:00	2029	9	29	CREDITO SIMPLE FIDE	DIRECTO CON DOCUMENTO	1	78109.99	0.0	78109.99	0.0	11.6600	1788.0	5.0	PLAN DE PAGOS	30.0	1643.30	0.0
22779	28950781	5	AURORA	GONGORA	RODRIGUEZ	F	1990-10-01 00:00:00	NaN	NaN	1	5001.0	MEXICO	MEXICANA	NaN	NaN	INDUSTRIAS MANUFACTURERAS	PRODUCTOS METALICOS ,MAQUINARIA Y EQUIPO.(I) INSTRUMENTOS Q	FABRICACION, REPARACION Y/O ENSAMBLE DE MAQUINARIA Y EQUIPO	FABRICACION DE EQUIPOS Y APARATOS DE AIRE ACONDICIONADO, REF	40704525	420827752.0	2024-11-05 00:00:00	2024	11	5	2029-09-29 00:00:00	2029	9	29	CREDITO SIMPLE FIDE	DIRECTO CON DOCUMENTO	1	180450.00	0.0	180450.00	0.0	11.6600	1788.0	5.0	PLAN DE PAGOS	30.0	3795.52	0.0
22780	28950790	5	MARIO ALBERTO	CASTILLON	RIOS	M	1966-07-17 00:00:00	NaN	NaN	1	5001.0	MEXICO	MEXICANA	NaN	NaN	INDUSTRIAS MANUFACTURERAS	PRODUCTOS METALICOS ,MAQUINARIA Y EQUIPO.(I) INSTRUMENTOS Q	FABRICACION, REPARACION Y/O ENSAMBLE DE MAQUINARIA Y EQUIPO	FABRICACION DE EQUIPOS Y APARATOS DE AIRE ACONDICIONADO, REF	40704518	420827681.0	2024-11-05 00:00:00	2024	11	5	2029-09-29 00:00:00	2029	9	29	CREDITO SIMPLE FIDE	DIRECTO CON DOCUMENTO	1	131116.26	0.0	131116.26	0.0	11.6600	1788.0	5.0	PLAN DE PAGOS	30.0	2757.88	0.0
22781	28950852	5	FIDEL	JOSE	JULIO	M	1980-08-27 00:00:00	NaN	NaN	10	800000.0	MEXICO	MEXICANA	NaN	NaN	CONSTRUCCION	CONSTRUCCION	CONSTRUCCION DE OBRAS DE URBANIZACION	CONSTRUCCION DE OBRAS DE URBANIZACION	40681011	420592612.0	2024-10-30 00:00:00	2024	10	30	2025-02-19 00:00:00	2025	2	19	2DO. PISO, M.N. HABILITACION O AVIO	2DO. PISO, BANCARIO	1	1865171.29	0.0	1865171.29	6.0	11.7440	112.0	1.0	CAPITAL E INTERES AL VCTO	1.0	1933318.81	0.0
22782	28951011	5	MARIO	RODRIGUEZ	CAMBRON	M	1968-07-17 00:00:00	NaN	NaN	1	5001.0	MEXICO	MEXICANA	NaN	NaN	INDUSTRIAS MANUFACTURERAS	PRODUCTOS METALICOS ,MAQUINARIA Y EQUIPO.(I) INSTRUMENTOS Q	FABRICACION, REPARACION Y/O ENSAMBLE DE MAQUINARIA Y EQUIPO	FABRICACION DE EQUIPOS Y APARATOS DE AIRE ACONDICIONADO, REF	40704519	420827690.0	2024-11-05 00:00:00	2024	11	5	2029-09-29 00:00:00	2029	9	29	CREDITO SIMPLE FIDE	DIRECTO CON DOCUMENTO	1	119700.66	0.0	119700.66	0.0	11.6600	1788.0	5.0	PLAN DE PAGOS	30.0	2517.97	0.0
22783	28951280	5	BRENDA	VAZQUEZ	ESPINOSA	F	1995-09-19 00:00:00	NaN	NaN	1	5001.0	MEXICO	MEXICANA	NaN	NaN	INDUSTRIAS MANUFACTURERAS	PRODUCTOS METALICOS ,MAQUINARIA Y EQUIPO.(I) INSTRUMENTOS Q	FABRICACION, REPARACION Y/O ENSAMBLE DE MAQUINARIA Y EQUIPO	FABRICACION DE EQUIPOS Y APARATOS DE AIRE ACONDICIONADO, REF	40704520	420827707.0	2024-11-05 00:00:00	2024	11	5	2029-09-29 00:00:00	2029	9	29	CREDITO SIMPLE FIDE	DIRECTO CON DOCUMENTO	1	55740.36	0.0	55740.36	0.0	11.6600	1788.0	5.0	PLAN DE PAGOS	30.0	1172.65	0.0
22784	28951682	7	NaN	NaN	NaN	NaN	NaN	PRUEBAS SAPI DE CV SOFOM ER	PRUEBAS S.A.P.I. DE C.V. S.O.F.O.M.E.R.	8	19373000.0	MEXICO	MEXICANA	NaN	NaN	SERVICIOS FINANCIEROS, DE ADMON Y ALQUILER DE BIENES MUEBLES	SERVICIOS FINANCIEROS DE SEGUROS Y FINANZAS	SERVICIOS FINANCIEROS DE SEGUROS Y FINANZAS	ARRENDADORAS FINANCIERAS (ORGANISMOS AUXILIARES DE CREDITO)	40709377	420876100.0	2025-01-03 00:00:00	2025	1	3	2026-01-03 00:00:00	2026	1	3	SIMPLE SIN GARANTIA REAL M.N.	DIRECTO CON DOCUMENTO	1	10000000.00	5000000.0	5000000.00	5.0	12.2408	273.0	2.0	INT. MENSUAL Y CAP. AL VENC.	1.0	5464130.03	NaN
22785	28958014	7	NaN	NaN	NaN	NaN	NaN	OPERACION Y MANTENIMIENTO A ESTACIONES DE GAS Y SERVICIOS INDUSTRIALES, S.A. DE C.V.	OMEGAS	19	1.0	MEXICO	MEXICANA	NaN	NaN	MINERIA Y EXTRACCION DE PETROLEO	PETROLEO Y GAS NATURAL	EXTRACCION DE PETROLEO Y GAS NATURAL	EXTRACCION DE PETROLEO CRUDO Y GAS NATURAL	40709379	420876128.0	2025-01-28 00:00:00	2025	1	28	2026-01-28 00:00:00	2026	1	28	SIMPLE SIN GARANTIA REAL DLS.	DIRECTO CON DOCUMENTO	54	10000000.00	0.0	10000000.00	5.0	6.7890	365.0	2.0	INT. MENSUAL Y CAP. AL VENC.	4.0	173496.36	NaN
22786	28958014	7	NaN	NaN	NaN	NaN	NaN	OPERACION Y MANTENIMIENTO A ESTACIONES DE GAS Y SERVICIOS INDUSTRIALES, S.A. DE C.V.	OMEGAS	19	1.0	MEXICO	MEXICANA	NaN	NaN	MINERIA Y EXTRACCION DE PETROLEO	PETROLEO Y GAS NATURAL	EXTRACCION DE PETROLEO Y GAS NATURAL	EXTRACCION DE PETROLEO CRUDO Y GAS NATURAL	40709380	420876137.0	2025-01-28 00:00:00	2025	1	28	2026-02-28 00:00:00	2026	2	28	SIMPLE SIN GARANTIA REAL DLS.	DIRECTO CON DOCUMENTO	54	20000000.00	0.0	20000000.00	5.0	6.7976	396.0	2.0	INT. MENSUAL Y CAP. AL VENC.	13.0	117069.64	NaN
22787	28958014	7	NaN	NaN	NaN	NaN	NaN	OPERACION Y MANTENIMIENTO A ESTACIONES DE GAS Y SERVICIOS INDUSTRIALES, S.A. DE C.V.	OMEGAS	19	1.0	MEXICO	MEXICANA	NaN	NaN	MINERIA Y EXTRACCION DE PETROLEO	PETROLEO Y GAS NATURAL	EXTRACCION DE PETROLEO Y GAS NATURAL	EXTRACCION DE PETROLEO CRUDO Y GAS NATURAL	40709381	420876146.0	2025-01-28 00:00:00	2025	1	28	2026-02-28 00:00:00	2026	2	28	SIMPLE SIN GARANTIA REAL DLS.	DIRECTO CON DOCUMENTO	54	15000000.00	0.0	15000000.00	5.0	7.4976	396.0	2.0	INT. MENSUAL Y CAP. AL VENC.	13.0	96844.00	NaN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length